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

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

111 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
compliments194658(None) 
complements1948181complements
compliment1848401compliment_
complement18510102complement_
complimented2153362complimented
couplements1756192couplements
comments142913883com___ments
commitments1653863commitments
compartments2094333compartments
complacent1846693complacent_
complainants1852663complainants
complaints1646003compl_aints
complects1766413compl__ects
complemental2054353complemental
complemented2154173complemented
compliant1549663compli_ant_
complices1739253complice__s
compliers1538293compli_e_rs
complies14314523compli_e__s
complimentary24133153complimentary
complimenting2252863complimenting
complines15312833compli__nes
complins14313113compli__n_s
components1646943comp_onents
comportments2094343comportments
condiments1548193co_ndiments
copayments1944313co_payments
couplement1647413couplement_
implements1647853_implements
orpiments1346003_orp_iments
accompaniments2461454accompaniments
accomplishments28221754accomplishments
aliments10311094___aliments
cajolements2254164cajolements
clients938094c___li_ents
comeliest13410034comeli_est_
comeliness1446994comeline_ss
commandments1852954commandments
commends15308464com___mends
comment1310317704com___ment_
commitment1555174commitment_
compartment1995084compartment_
compends15378254comp___ends
competent15411254comp_etent_
compilers1537054comp_ile_rs
compiles14311984comp_ile__s
complacence1853004complacence
complacences1953014complacences
complacency2152504complacency
complacently2353234complacently
complainant1753614complainant_
complainers1744474complaine_rs
complains1549194compl_ain_s
complaint15410254compl_aint_
complaisant1753234complaisant_
compleat14710154compl__eat_
complect1659014compl__ect_
complementary24123594complementary
complementing2253614complementing
complete143412054compl__e_te
completeness1854634completeness
completers16298324complete_rs
completes153212924compl__etes
completest16297874completest_
complexes22308104compl__exes
complexest23265594complexest_
complexness2453094complexness
compliance1844934compli_ance
compliances1945034compliances
compliancy2153754compli_ancy
compliantly2053834compli_antly
complicate1847624compli_cate
complicates1947054complicates
complice1639334complice___
complicit1747434compli_cit_
complicity2145694compli_city
complied1539674compli_e__d
complier14310254compli_e__r
complin13312074compli__n__
compline14313554compli__n_e
complots1438164compl___ots
component15411084comp_onent_
comportment19105464comportment_
comprehends21103214comprehends
comprises15510944comprise__s
comprizes2468944comprize__s
condiment14410854co_ndiment_
conferments1848324conferments
confluents1545414confl_uents
containments1655784containments
continents1249564co_ntinents
coparents1347974co_p_arents
copayment1845894co_payment_
copresents1446454co_presents
coresidents1484274coresidents
couplets12389874coupl__e_ts
couplings1435544coupli__ngs
emblements1647794_emblements
emollients1242834emolli_ents
emoluments1455424_emoluments
employments2054244_employments
habiliments1852554habiliments
impairments1753874_impairments
impalements1746434_impalements
impediments1874474_impediments
implement1549534_implement_
muniments1346144__muniments
nonpayments1854154nonpayments
orpiment1247974_orp_iment_
supplements1754594supplements
worriments1544154wo_rriments

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 Limit1488191119.17016228.9
3Display Results1111110.0631761.9
 (SQL Overall)1786911119.65618505.7
 
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.