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

125 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
commands1531882(None) 
command14399211command_
commando15275751commando
commandos16245961commandos
commends15308461commends
commanded17136502commanded
commander16127402commander
commanders17146682commanders
commandoes17255262commandoes
commas124814572comma__s
commend144010182commend_
comments142913882comments
commons13311042common_s
communes143411242communes
compends15378252compends
cowhands1765262cowhands
gormands1266562gormands
summands1344712summands
armbands1355143armbands
bombards1536493bombards
caimans113811783caiman_s
caymans14349513cayman_s
coamings13349293coamings
cofounds1444713cofounds
coheads13289233cohea_ds
coleads102911423colea_ds
collards113310193collards
comade114415323co_ma_de
comakes154413643co_makes
comas95833003co_ma__s
comates114123643co_mates
combats13311683comba_ts
combineds16255283combineds
combines142814623combines
combings15348323combings
comings124013533co_mings
comma114514793comma___
commandant1754813commandant
commandants1853373commandants
commandeer17124113commandeer
commandeers18123183commandeers
commandery20134253commandery
commanding1845923commanding
commata1338483comma_ta
commence16149103commence
commences17139583commences
commendam1544953commendam
commendams1644303commendams
commended17137013commended
commender16167923commender
commenders17137143commenders
comment1310317703commen_t
commies133718453comm_ies
commits133812383comm_its
commixes2177353commixes
commode1438123comm_ode
commodes1539093commodes
common12310803common__
commoner142710633commoner
commoners15339783commoners
commonest1549253commonest
commonly1744963commonly
commoves1736963commoves
communal1446353communal
communards1743403communards
commune13329363commun_e
communed15338213communed
communer14349303communer
communers15338413communers
communise1546803communise
communism1445633communism
communist1548113communist
commutes143011893commutes
compacts16368903compacts
companies15311803companies
company1619711143compan_y
compares143816433compares
comparts144210833comparts
compas125817063compa__s
compass13379563compa_ss
compend144010303compend_
compounds1654503compounds
comrade12139213comra_de
comrades13149773comrades
contends112810573contends
coolants1039943coolants
corbans11313173corban_s
cosmids1237633cosm_ids
costards113510793costards
cotans81317923co_tan_s
courants10310803courants
cowards1339613co_wards
cowbanes1537423cowbanes
cowbinds1634453cowbinds
cowhand1665933cowhand_
cowman13910373cowman__
croplands1445373croplands
cummins1358963cummin_s
demands114311413_demands
dolmans10479683dolman_s
formants13269953formants
gormand1157453gormand_
gourmands1343313gourmands
hogmanes1446783hogmanes
hollands12247273hollands
homelands1545443homelands
lowlands1244373lowlands
mommas94110653momma__s
nomads94711603no_ma_ds
norlands936443norlands
normande1145933normande
osmunds1042883_osmunds
pompanos1445243pompanos
recommends1763163recommends
remands104914883_remands
rimlands1145243rimlands
robands10219863ro_bands
romanos94311483ro_manos
romans84620243ro_man_s
solands84412343so_lands
somans84619303so_man_s
summand1236263summand_
tomans85419133to_man_s
towmonds1493493towmonds
womans114613653wo_man_s

Search took 7 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.1561145455.1
2DLD Change Limit1461621256.45322650.2
3Display Results1251250.0631984.1
 (SQL Overall)1786911256.67226782.2
 
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.