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

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

91 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
comparisons175397(None) 
comparison1644351comparison_
caparisons1443672c_aparisons
companions1697262compani_ons
compassions1745772compassions
caparison1343983c_aparison_
compactions1946543compactions
companion1577683compani_on_
comparators1785683comparators
comparing162410583compari__ng
compassion1645983compassion_
compatriots1753543compatri_ots
comprisals1643713comp_risals
comprises15510943comp_ris_es
comprising1748633comp_rising
compulsions1744593compulsions
imprisons1344913_imp_risons
bombardons1752054bombar_dons
campaigns1643474campa_i_gns
campions143511294camp__i_ons
caparisoned1691754c_aparisoned
clarions10310494c__lari_ons
coaptations1547544coaptati_ons
coarsens10348124co__ar_sens
cognations1339594cognati_ons
collations12312854collati_ons
commissions1745264commissions
commotions1686844commoti_ons
communions1656184communi_ons
compaction1846754compaction_
compactors18256254compa_ctors
companies15311804compani__es
companioned1853604compani_oned
comparatists1853734comparatis_ts
comparator1665804comparato_r
comparers15319394compar__ers
compares143816434compar___es
comparting17188384compar_ting
compartment1995084compartment
compartments2094334compartments
comparts144210834compar___ts
compass13379564compa__s__s
compasses1547394compa__sses
compassing1746554compa_ssing
compatibles19134144compatibles
compatriot1655964compatri_o_t
compering163414164comperi__ng
competitions1845534competitions
competitors1753554competitors
compilations1848684compilati_ons
complains1549194complai__ns
complaisant1753234complaisant
completions1746914completions
complexions2443634complexions
complins14313114comp_li__ns
compositions1846254compositions
compositors1754384compositors
compradors1743784comp_radors
compress1439054comp_res__s
compresses1647774comp_resses
compressions1856404compressions
compressors1754194compressors
comprisal1544514comp_ris_al
comprise14310814comp_ris__e
comprised1648054comp_ris_ed
comprizes2468944comp_ri_zes
comprizing2647464comp_rizing
compulsion1644674compulsion_
computations1848124computati_ons
computists1644694computis_ts
conations111318904co_nati_ons
connations12312944connati_ons
contagions1346604contagi_ons
conversions1648274conversions
cooptions13107764coop_ti_ons
copatrons1346334co_pa_trons
coprisoner1453564co_p_risoner
coprisoners1553124co_p_risoners
corrasions1246354corrasi_ons
coumarins1347024coumari__ns
cumarins1238644cum_ari__ns
empoisons1343644_emp_oisons
impassions1444844_impassions
imprison1244794_imp_rison_
malisons1048784__m_alisons
nonpersons1285504nonper_sons
orisons7310564_o___risons
parsons93516874___par_sons
prisons9313224___p_risons
tompions12267004tomp__i_ons
warisons1136904___warisons

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819919.04616451.4
3Display Results91910.0461978.3
 (SQL Overall)178691919.51518779.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.