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

101 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
bifurcations198293(None) 
bifurcation1863371bifurcation_
bifurcating1952612bifurcati_ng
furcations1547532__furcations
trifurcations1852862trifurcations
bifurcates1742713bifurcat__es
bilocations1545293bi_locations
diffractions2153273diffractions
figurations1545073figur_ations
furcation1448353__furcation_
infuriations1547443infuriations
obfuscations1951893obfuscations
trifurcation1753273trifurcation_
abjurations2045144abjur_ations
adjurations1944824adjur_ations
affirmations2053234affirmations
altercations1446364altercations
basifications20137064basif_ications
bifunctional19132854bifunc_tional
bifurcate1642974bifurcat___e
bifurcated1842394bifurcat__ed
bijections21134934bi_jec_tions
bilections14136504bi_lec_tions
bilocation1446124bi_location_
bipartitions16152544bipartitions
bisections14136734bi_sec_tions
cofunctions1845004cofunc_tions
conurbations1646654conurbations
coruscations1645224coruscations
defalcations1845194defalcations
defecations1778994def_ecations
deformations1846824deformations
deifications18410654deif_ications
demarcations1746124demarcations
diffraction2053494diffraction_
disfunctions1854514disfunc_tions
dislocations15136974dislocations
distractions1548714distractions
divarications1955494divarications
durations10311464__dur_ations
edifications1848694edif_ications
educations1339224_edu_cations
expurgations2274124expurgations
figuration1445914figur_ation_
filtrations1445624filtr_ations
fimbriations1943324fimbriations
formations1538194__formations
fractions1449104__f_ractions
functions1437744__func_tions
furcating1537784__furcati_ng
hibernations1744044hibernations
imbrications1845664_imbrications
imprecations1846244_imprecations
inculcations1666314inculcations
incurvations1746384incurvations
indications14310974_indications
indurations1249584indur_ations
infarctions1645024infarc_tions
informations17127034informations
infractions1646964_infractions
infuriation1448244infuriation_
inunctions1246754_inunc_tions
inundations12125534_inundations
invocations1647064_invocations
iterations10413824_iter_ations
laureations1145574_laureations
liberations1358934liber_ations
librations12149064li_br_ations
liquations1945614liqu__ations
liquidations2242794liquidations
literations11610574liter_ations
maturations1348434matur_ations
migrations13168674mi_gr_ations
miscreations1647044miscreations
misfunctions1953714misfunc_tions
mislocations16145654mislocations
nitrations10312034ni_tr_ations
obfuscation1852124obfuscation_
objurgations2252234objurgations
obscurations1644014obscur_ations
obturations13116424obtur_ations
purgations1346744__purgations
reformations1747594reformations
refractions16127724ref_ractions
refutations1448674refu_tations
reifications17411824reif_ications
saturations1148574satur_ations
simulations1368394simu_lations
sinuations1039394sinu__ations
situations1038424situ__ations
suffocations2053094suffocations
sulcations1289584__sulcations
susurrations1244334susurrations
titrations1039174ti_tr_ations
trifurcating1852144trifurcati_ng
triturations1245684tritur_ations
truncations1344764_truncations
unifications1748044unif_ications
usurpations1343474_usurpations
vibrations15157374vi_br_ations
vindications1845674vindications

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 Filter1786911247900.1561145455.1
2DLD Change Limit1247901018.97013911.9
3Display Results1011010.0631603.2
 (SQL Overall)1786911019.18919446.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.