Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “commuted” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
commuted1528896(None) 
communed15338201communed
commute134310421commute_
commuter143010131commuter
commutes143011871commutes
computed154110941computed
coempted1535332coempted
combated1539822combated
combusted1644632combusted
commented16129602commented
comminuted17224572comminuted
committed1645712committed
commixed2264742commixed
commoved1844762commoved
commune13329352commune_
communer14349292communer
communes143411232communes
commutated1745412commutated
commuters15378882commuters
competed154113592competed
compted143813522co_mpted
compute134513652compute_
computer144511502computer
computes143914532computes
confuted1437672confuted
cornuted1137462cornuted
campused1535253campused
cemented1338373cemented
chuted124611843c__huted
clouted104212163c_louted
coacted123611603co_acted
coapted123911493co_apted
coasted104015943co_asted
coated94927033co__ated
coedited1237823coedited
coequated2144823coequated
cohosted1436133cohosted
collated113615063collated
colleted113011653colleted
colluded12296453colluded
coloured1148303coloured
columned1334923columned
comate104124843co_mate_
comates114123633co_mates
combater1439373combater
combatted1644653combatted
combed135516543co_m_bed
combined15269183combined
comforted17315963comforted
command14399213comm_and
commanded17136503commanded
commata1338483commat_a
commenced18157133commenced
commend144010183comm_end
commended17137013commended
commenter151410683commenter
commerced18125463commerced
commie124215523comm_ie_
commies133718443comm_ies
comminute1596143comminute_
comminutes1685613comminutes
commit124016703commit__
commits133812373commit_s
committee1546233committee
commixes2177343commixes
commode1438123commode_
commodes1539093commodes
commoner142710633commoner
commove1635963commove_
commoves1736963commoves
communal1446353communal
communard1644153communard
communers15338403communers
communised1744943communised
communized2645273communized
commutate1547043commutate
commutates1646453commutates
commuting16288413commuting
compacted18297363compacted
compared153811823compared
comparted16338423comparted
comped135919873co_m_ped
compered153414923compered
compete134716553compete_
competes144117243competes
compiled1537813compiled
completed162810263completed
complied1539673complied
comported16319533comported
composed154612063composed
composted16378813composted
compote135616463compote_
compotes144716513compotes
computers15339733computers
comte96125473co_m_te_
comtes106222813co_m_tes
conduced14136953conduced
conducted1547303conducted
confused1437033confused
confute1239253confute_
confuter1338503confuter
confutes1339833confutes
conjured18117893conjured
connoted1138863connoted
consulted1277923consulted
consumed1337923consumed
contused1138443contused
coopted123710763co_opted
cornute939633cornute_
corrupted1444503corrupted
corseted11311473corseted
cosseted1178343cosseted
costed95623113co__sted
costumed1365033costumed
coted85033853co___ted
counted103815803co_unted
couped115019313co__uped
courted103514913co_urted
couter84930203co__uter
coveted133011523co_veted
cremated133412963cremated
fomented1437803fomented
gemmated14336293gemmated
grommeted1553163grommeted
immured1235063_immured
imputed1236533_imputed
louted74920693lo__uted
muted85023383___muted
omitted10347893_omitted
outed65429063_o__uted
permuted1336703permuted
polluted1135433polluted
pommeled1543103pommeled
pouted94021393po__uted
recomputed1744723recomputed
routed75624333ro__uted
scouted104112033sco__uted
summated13298833summated
summited13246393summited
tommed113310143tomm__ed
touted74419743to__uted
voluted11297943vo_luted
vomited1337253vo_mited

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1701051123.5
2DLD Change Limit1461621436.84621350.0
3Display Results1431430.0602383.3
 (SQL Overall)1786911437.07625253.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.