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 “commandes” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
commanded17136501commanded
commander16127401commander
commanders17146681commanders
commandoes17255261commandoes
commandos16245961commandos
commands15318821command_s
command14399212command__
commandeer17124112commandeer
commandeers18123182commandeers
commandery20134252commandery
commando15275752command_o
commences17139582commences
commended17137012commended
commender16167922commender
commenders17137142commenders
commends15308462commend_s
commodes1539092comm_odes
communes143411242commun_es
companies15311802companies
comrades13149772comra_des
chamades16138653chama_des
cockades1738433cocka_des
colander1139033co_lander
colanders1238013co_landers
comade114415323co_ma_de_
comakes154413643co_ma_kes
comanages1446533co_manages
comates114123643co_ma_tes
combineds16255283combineds
combines142814623combin_es
commandant1754813commandant
commandants1853373commandants
commanderies1953383commanderies
commanding1845923commanding
commandment1753823commandment
commandments1852953commandments
commas124814573comma___s
commence16149103commence_
commenced18157133commenced
commencer17147803commencer
commencers18156373commencers
commend144010183commend__
commendam1544953commendam
commendams1644313commendams
commented16129613commented
commenter151410693commenter
commenters16139483commenters
comments142913883commen_ts
commerces17147233commerces
commies133718453comm__ies
commingles1744093commingles
comminutes1685623comminutes
commixes2177353comm_ixes
commode1438123comm_ode_
commonages1745913commonages
commoner142710633common_er
commoners15339783commoners
commonest1549253common_est
commonness1644363commonness
commons13311043common__s
commoves1736963comm_oves
commune13329363commun_e_
communed15338213commun_ed
communer14349303commun_er
communers15338413communers
communise1546803communise
communises1646563communises
communizes2546253communizes
commutes143011893comm_utes
compadres16266413compadres
companied1648023companied
compares143816433compa_res
compasses1547393compasses
compends15378253compend_s
comrade12139213comra_de_
coriander1245663coriander
corianders1344913corianders
coromandel1552833coromandel
coromandels1652063coromandels
corrades111211263corra_des
courantes1148883courantes
couvades1435613couva_des
cowbanes1537423cowban_es
cowhands1765263cowhand_s
dolmades1245463dolma_des
gormands1266563gormand_s
hogmanes1446783hogman_es
normande1145943normande_
pomades123711733po_ma_des
pomander1347083po_mander
pomanders1436223po_manders
romances12310793ro_mances
summands1344713summand_s

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 Filter1786911486410.420425454.8
2DLD Change Limit148641936.59322545.3
3Display Results93930.0462021.7
 (SQL Overall)178691937.05925313.9
 
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.