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

242 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
consolations144974(None) 
consolation13410981consolation_
condonations1548002condonations
conflations16411142con_flations
congelations1549732congelations
connotations1447282connotations
consociations1747512consociations
consolidations1754742consolidations
consultations1546932consultations
convocations1947362convocations
convolutions1745192convolutions
insolations1149182_insolations
nonsolutions1254172nonsolutions
cancelations1657093cancelations
coagulations1546513coagulations
coevolutions1754083coevolutions
collations12312853co__llations
collocations1646403collocations
colorations13911893co_lorations
compilations1848683compilations
conations111318903con___ations
conciliations1747203conciliations
concoctions1448253conco_ctions
condonation1448853condonation_
conflation15412083con_flation_
conformations2046723conformations
confutations1767793confutations
congelation14410343congelation_
conglobations1853943conglobations
conjugations2245863conjugations
conjurations2148493conjurations
connations12312943con__nations
connotation1347983connotation_
consecrations1749213consecrations
consecutions1647053consecutions
conservations1849093conservations
consignations16105933consignations
consociation1648193consociation_
consolatory1684963consolat_ory
consolidation1655153consolidation_
conspirations1747723conspirations
constellations1654403constellations
constipations1747683constipations
consultation1447473consultation_
consummations1955153consummations
consumptions1845143consumptions
contortions1348683conto_rtions
conurbations1646663conurbations
convocation1847883convocation_
convolution1645123convolution_
copulations151111113co_pulations
coronations13410703co_ronations
corotations1349763co_rotations
corporations16129483corporations
correlations1447863correlations
desolations12310593_desolations
disconsolations1863203disconsolations
insolation10410213_insolation_
insulations11310233_insulations
isolations10310693__isolations
nonsolution1154743nonsolution_
solations9814623___solations
absolutions1344714_absolutions
angulations1268054_angulations
annotations1146884_annotations
annulations1167834_annulations
calculations1647074calculations
cancelation1547774cancelation_
cancellations1754394cancellations
cantillations1545734cantillations
carbonations1644844carbonations
caseations1258304c_as_eations
cassations1276874c_as_sations
castrations13410054c_astrations
causations1268144caus__ations
cessations1256474c_es_sations
chelations1539074c__helations
circulations1648484circulations
cisplatins1444594c_isplati_ns
coagulation1447274coagulation_
coalitions1247924co__alitions
coaptations1547544co_aptations
coarctations16114494coarctations
coeducations1745874coeducations
coevolution1654224coevolution_
cogitations1448904co_gitations
cognations1339594co__gnations
collation11313994co__llation_
colligations1556844colligations
collimations1656874collimations
collocation1547174collocation_
coloration12913184co_loration_
combinations1897924combinations
comminations18810484comminations
commotions1686844commo__tions
commutations1847264commutations
compellations1954814compellations
compilation1749314compilation_
completions1746914co_mpletions
compositions1846254compositions
computations1848124computations
conation101420884con___ation_
conceptions17410594con_ceptions
conciliation1648234conciliation_
conclusions1544884con_clusions
concoction1348234conco_ction_
concretions1549294con_cretions
condemnations1845404condemnations
condensations1646274condensations
conditions13410104con__ditions
condolatory1754234condolat_ory
conductions1649664con_ductions
confabulations2162804confabulations
confections18411394con_fections
confirmations2055674confirmations
confiscations2044954confiscations
conflating16410004con_flati_ng
conflictions1945224conflictions
conformation1947324conformation_
confrontations1962784confrontations
confutation1668724confutation_
congestions1449314con_gestions
conglobation1754254conglobation_
congregations17186414congregations
conjugation2146624conjugation_
conjunctions2345384conjunctions
conjuration2049514conjuration_
connation11314264con__nation_
connections15410704con_nections
conniptions1546034con_niptions
connotational1554154connotational
conscriptions1955004conscriptions
consecration1649784consecration_
consecution1547314consecution_
conservation1749404conservation_
considerations1764844considerations
consignation15136314consignation_
consociating1755574consociati_ng
consociational1853554consociational
consolidating1753284consolidati_ng
consolidators1653294consolidat_ors
consoling12310874consol__i_ng
consorting13410744conso_rti_ng
consortiums1562844conso_rtiums
conspiration1648384conspiration_
constatives1646934cons_tatives
constellation1554804constellation_
consternations16116044consternations
constipation1648564constipation_
constitutions1554864constitutions
constrains1249724constra_i_ns
constrictions1747784constrictions
constructions1747714constructions
consulates12711104consulat__es
consulting1349084consul_ti_ng
consultors1286404consul_t_ors
consummation1855294consummation_
consumption1745424consumption_
contagions1346604con__tagions
contemplations2074734contemplations
contentions13412094con_tentions
contestations1547734contestations
continuations1547144continuations
contortion1248664conto_rtion_
contractions16410404contractions
contraptions1647644contraptions
contritions13410914con_tritions
conurbation1547464conurbation_
convections18411494con_vections
conventions16410534con_ventions
conversations1847454conversations
convictions1848044con_victions
convocational2054474convocational
convoluting1744204convoluti_ng
convulsions1644314convul_sions
cooperations1659194cooperations
cooptions13107764co__o_ptions
copulation141111954co_pulation_
coronation12412074co_ronation_
corotation12410974co_rotation_
corporation151210654corporation_
correlation1358554correlation_
corrugations1565484corrugations
coruscations1645244coruscations
covariations1745984covariations
crenelations1446184crenelations
crenellations1553574crenellations
crenulations1446494crenulations
cumulations1547434c_umulations
cunctations1576154cun_ctations
cupellations1643804cupellations
denotations1239854den_otations
desolation11311404_desolation_
disconsolation1763414disconsolation_
dissolutions13144924dissolutions
donations101112354don___ations
etiolations1147394_etiolations
exsolutions1844014_exsolutions
formulations1745644formulations
immolations1545474_immolations
inflations13310324_in_flations
inhalations14126744_inhalations
innovations1445264_innovations
inoculations1457684inoculations
inosculations1554424inosculations
insolating1149154_insolati_ng
insulation10311664_insulation_
intonations1149524_intonations
invocations1647064_invocations
involutions1445904_involutions
ionizations2049894ion_izations
isolation9311644__isolation_
lobulations1346214lo_bulations
mensurations1445714mensurations
modulations14147264mo_dulations
morulations13148164mo_rulations
nodulations12147004no_dulations
notations91512974__n_otations
novations12139004__n_ovations
oblations1139374_o__blations
osculations1348374_osculations
ovulations1337974_o_vulations
ozonations1945144_o_zonations
percolations1648054percolations
personations1448394personations
podsolizations26164374podsolizations
populations15148714po_pulations
postulations14127734postulations
renovations1448424ren_ovations
resolutions11117794_resolutions
sensations1059854sens__ations
solation8916154___solation_
solutions988884___solutions
solvations1336834___solvations
sonications1349954son_ications
syncopations1952884syncopations
translations1258374trans_lations
undulations1246054_undulations
vacuolations1743784vacuolations
ventilations1547404ventilations
violations1337964__violations
zonations18139314zon___ations

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 Filter1786911247900.393454684.5
2DLD Change Limit1247902426.70318617.0
3Display Results2422420.1401728.6
 (SQL Overall)1786912427.23624694.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.