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

110 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
compensations1913618(None) 
compensation18126501compensation_
commendations2055802commendations
compellations1954812compellations
compensating1955002compensati_ng
compensational2073522compensational
compensators1854372compensat_ors
condensations1646272condensations
decompensations22103042decompensations
cementations1659013cem_entations
combinations1897923combin_ations
commendation1946513commendation_
commensurations21182583commensurations
comminations18810483commin_ations
compellation1855103compellation_
compensates1745723compensat__es
compensative2154653compensati_ve
compensator1754673compensat_o_r
compensatory2163643compensat_ory
competitions1845533compe_titions
compilations1848683comp_ilations
complexations26134013complexations
complications2147433complications
compositions1846253comp_ositions
compunctions20145693compun_ctions
compurgations20123893compurgations
computations1848123comp_utations
condensation1546783condensation_
conversations1847453conversations
cooperations1659193coope_rations
decompensation2193363decompensation_
dispensations1655483dispensations
fomentations1746793fom_entations
bombinations1884594bombin_ations
catenations1348364c_aten_ations
cementation1559704cem_entation_
cessations1256474c___essations
coacervations2053874coacervations
coaptations1547544coap__tations
cogenerations1655914co_generations
cognations1339594co__gn_ations
colonisations15216174colonisations
columniations1764794columniations
combination17108804combin_ation_
combustions1744534com_bus_tions
commemorations1953444commemorations
commensalisms1873754commensalisms
commensuration20162984commensuration_
commentating1957044commentati_ng
commentators1854794commentat_ors
commination171111644commin_ation_
comminutions1894314commin_utions
communications22105754communications
communizations29126104communizations
commutations1847264com_mutations
compactions1946544comp__actions
companions1697264comp___anions
compassions1745774comp_as_sions
compendious1853374compen__dious
compensate1646144compensat___e
compensated1844864compensat__ed
competition1755774compe_tition_
compilation1749314comp_ilation_
completions1746914comp__letions
complexation25144244complexation_
complication2048204complication_
composition1746794comp_osition_
compressions1856404compres_sions
compulsions1744594compuls__ions
compunction19115904compun_ction_
compunctious20143034compun_ctious
compurgation19134184compurgation_
computation1748714comp_utation_
conations111318904co___n_ations
concentrations1877074concentrations
condemnations1845404condemnations
condensational1753654condensational
condonations1548004condon_ations
congelations1549734conge_lations
congestions1449314conge_s_tions
connations12312944co___nnations
consecrations1749214consecrations
conservations1849094conservations
contentions13412094conten__tions
contestations1547734contestations
continuations1547144continuations
conventions16410534conven__tions
conversation1747804conversation_
cooperation15410024coope_ration_
copulations151111114co_p_ulations
coronations13410704co_ron_ations
corporations16129484corp_orations
correlations1447864corre_lations
crenations12511694c__ren_ations
cupellations1643804c_upellations
decompensating2262524decompensati_ng
dispensation1555604dispensation_
dominations14611044dom_in_ations
emendations1446054_em_endations
fomentation1647714fom_entation_
homogenisations21192634homogenisations
impetrations1645444_impetrations
lamentations1495984lam_entations
mentations12312584__m_entations
nominations13410534nom_in_ations
operations12312954_o_pe_rations
orientations1246914_orientations
ostentations1246124_ostentations
recommendations22113094recommendations
sensations1059854___sensations

Search took 6 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 Filter178691950240.343520965.0
2DLD Change Limit950241105.34317784.8
3Display Results1101100.0801375.0
 (SQL Overall)1786911105.76630990.5
 
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.