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

155 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
complications214743(None) 
complication2048201complication_
compilations1848672comp_ilations
complexations26134012complexations
complicating2145632complicati_ng
implications1847022_implications
applications1846773_applications
codifications21127623codifications
colligations1556833co_lligations
collimations1656873co_llimations
collocations1646403co_llocations
combinations1897913com_binations
comminations18810483com_minations
communications22105753communications
compactions1946533comp_ac_tions
compellations1954803compellations
compensations19136183compensations
compilation1749313comp_ilation_
completions1746903compl__etions
complexation25144243complexation_
complicacies1962793complicaci_es
complicates1947053complicat__es
complicities2055963compliciti_es
complicitous2052393complicit_ous
compunctions20145693compunc_tions
compurgations20123893compurgations
computations1848123comp_utations
conflictions1945223conflic_tions
duplications1746283_duplications
explications2347533_explications
implication1747773_implication_
nonimplications21122883nonimplications
plications14310493___plications
replications16811053_replications
supplications1954913supplications
triplications1795073triplications
amplifications2384754_amplifications
application1747474_application_
bombinations1884584bom_binations
canalizations24410434canalizations
capitations1549854c_ap_itations
captivations1945344c_aptivations
ciliations121111004c__ili_ations
citifications2048544citifications
civilisations1853644civilisations
civilizations2747274civilizations
claudications1852884claudications
coalifications2155704coalifications
coalitions1247924co_ali__tions
coaptations1547544coap__tations
cocultivations2152764cocultivations
codification20108074codification_
coeducations1745874co_educations
cogitations1448904co__gitations
cohabitations2053454cohabitations
collations12312854co__l_lations
collections1547934co_llec_tions
colligation1457444co_lligation_
collimation1557574co_llimation_
collocation1547174co_llocation_
colonisations15216174colonisations
colonizations24229424colonizations
colorations13911894co__lorations
colorizations241410354colorizations
combination17108804com_bination_
commendations2055804commendations
commination171111644com_mination_
comminutions1894314com_minutions
communication21106214communication_
communizations29126104communizations
commutations1847264com_mutations
compaction1846754comp_ac_tion_
companions1697264comp___anions
compellation1855104compellation_
compensation18126504compensation_
competitions1845534comp_etitions
complains1549184compl__a_i_ns
complecting2045754complec_ti_ng
completion1647304compl__etion_
complexions2443624compl__exions
complicate1847624complicat___e
complicated2046094complicat__ed
complicatedly2561704complicatedly
complicatedness24102074complicatedness
compositions1846254comp_ositions
compunction19115904compunc_tion_
compunctious20143034compunc_tious
compurgation19134184compurgation_
computation1748714comp_utation_
conciliations1747204conciliations
confiscations2044954confiscations
conflations16411144confl__ations
confliction1845234conflic_tion_
conglobations1853944conglobations
consociations1747514consociations
consolidations1754744consolidations
conspirations1747724conspirations
constipations1747684constipations
convictions1848044co_nvic_tions
convocations1947364co_nvocations
cooperations1659194coop_erations
coordinations1684994coordinations
copulations151111114co_p_ulations
cornifications2145954cornifications
corporations16129484corp_orations
coruscations1645244co_ruscations
covariations1745984covari_ations
creolizations2457884creolizations
crepitations1647474crep_itations
cumulations1547434cumul__ations
cuspidations1743344cusp_idations
cyclizations2845754c_yclizations
domestications19143994domestications
dominations14611044dom__inations
duplication1647294_duplication_
explication2248454_explication_
focalizations2748994focalizations
foliations1399944fo__li_ations
formalizations28146984formalizations
fornications1755394fo_rnications
hominizations2767454hominizations
homologations19102344homologations
humifications2345854humifications
humiliations1784554humili_ations
imbrications1845684_imbrications
implicating1855744_implicati_ng
imprecations1846274_imprecations
localizations2449794localizations
medications1649934__medications
mobilizations2687874mobilizations
modifications21106984modifications
moralizations24410814moralizations
nominations13410534nom__inations
nonimplication20102854nonimplication_
normalizations25147544normalizations
notifications1848234notifications
novelizations2556364novelizations
obligations1446144_o_bligations
placations1438584___placations
plication13311684___plication_
pollinations1447234po_llinations
publications1845834_publications
ramifications2087534ramifications
reapplications2054254reapplications
recompilations2054944recomp_ilations
reduplications1964534reduplications
replication15712014_replication_
romanizations2459284romanizations
simplifications2463194simplifications
sonications1349954so__nications
supplication1855394supplication_
triplication1695384triplication_
umbilications1994414umbilications
vocalizations2749274vocalizations
zombifications3263764zombifications

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.1261418182.5
2DLD Change Limit950241555.11018595.7
3Display Results1551550.0931666.7
 (SQL Overall)1786911555.32933531.8
 
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.