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 “command” 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.

161 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
command1439921(None) 
commando15275751commando
commands15318821commands
commend144010181commend
comma114514792comma__
commanded17136502commanded
commander16127402commander
commandos16245962commandos
commas124814572comma_s
commata1338482commata
commends15308462commends
comment1310317702comment
common12310802common_
commons13311042commons
commune13329362commune
communed15338212communed
company1619711142company
compend144010302compend
cowhand1665932cowhand
cowman13910372cowman_
gormand1157452gormand
summand1236262summand
armband1265983armband
bombard1437333bombard
bowman13129853bowman_
cabman123812503cabman_
caiman103615663caiman_
caimans113811783caimans
carman103920743carman_
cayman133613213cayman_
caymans14349513caymans
clamant11312433clamant
coaming123818323coaming
cofound1335513cofound
cohead123811123cohea_d
colead94114643colea_d
collard103712923collard
coma87134853co_ma__
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comal95125133co_ma_l
comas95833003co_ma_s
comate104124843co_mate
combat12316753comba_t
combated1539823combated
combats13311683combats
combed135516543co_mbed
combine133014723combine
combined15269183combined
combing143714733combing
coming114225453co_ming
commandant1754813commandant
commandeer17124113commandeer
commanders17146683commanders
commandery20134253commandery
commanding1845923commanding
commandoes17255263commandoes
commence16149103commence
commenced18157133commenced
commendam1544953commendam
commended17137013commended
commender16167923commender
commented16129613commented
comments142913883comments
commie124215523comm_ie
commies133718453commies
commit124016703comm_it
commits133812383commits
commix19407763comm_ix
commixed2264743commixed
commixt20357623commixt
commode1438123commode
commoner142710633commoner
commonly1744963commonly
commove1635963commove
commoved1844763commoved
communal1446353communal
communard1644153communard
communer14349303communer
communes143411243communes
commute134310443commute
commuted15288983commuted
commy144712643comm__y
compact153712213compact
companied1648023companied
compare135814993compare
compared153811823compared
compart134016003compart
compas125817063compa_s
compass13379563compass
comped135919873co_mped
compends15378253compends
comping143518593comping
compone136517193compone
compony1613011913compony
compound1555993compound
compted143813523compted
comrade12139213comrade
congaed11399743congaed
contend103511893contend
coolant9316463coolant
corban10314693corban_
corbans11313173corbans
cormoid12310403cormoid
cosmid11810643cosm_id
costard104113353costard
cotan71521783co_tan_
cotans81317923co_tans
courant9317973courant
coward12411673co_ward
cowbane1437673cowbane
cowbind1536613cowbind
cowhands1765263cowhands
cowmen13810923cowmen_
cropland1346303cropland
cummin1288783cummin_
cummins1358963cummins
demand104314253_demand
dolman95312403dolman_
dolmans10479683dolmans
dormant102814373dormant
foeman11311233foeman_
formant123416003formant
gormands1266563gormands
gourmand1243263gourmand
hogmane1336343hogmane
holland11349473holland
homeland1446233homeland
immane1038883_immane
lowland1134693lowland
momma85111053momma__
mommas94110653momma_s
nomad86016183no_ma_d
nonman8412363nonman_
norland837163norland
normande1145943normande
osmund933803_osmund
pompano1345203pompano
potman102813573potman_
recommend1664323recommend
remand95618963_remand
rimland1035663rimland
roband92310723ro_band
rodman949713rodman_
roman75424823ro_man_
romano84912943ro_mano
romans84620243ro_mans
socman1039813socman_
soland75115043so_land
soman75024903so_man_
somans84619303so_mans
summands1344713summands
toman75724053to_man_
tomans85419133to_mans
tommed113310143tomm_ed
tomming12359243tomming
towmond1394203towmond
woman105818003wo_man_
womaned1337213wo_maned
womans114613653wo_mans

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271616.70319995.1
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.17224915.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.