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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
furcations154753(None) 
furcation1448351furcation_
bifurcations1982932bifurcations
durations10311462dur_ations
formations1538202formations
fractions1449102f_ractions
functions1437742func_tions
furcating1537782furcati_ng
purgations1346742purgations
sulcations1289582sulcations
aerations9317903aer_ations
arcuations1249343_arcuations
auctions104012143au_c_tions
avocations15168683avocations
bifurcation1863373bifurcation_
carnations12311353carnations
cations94524143___cations
creations112614543_creations
cunctations1576153cunctations
darnations1138413darnations
duration9312693dur_ation_
educations1339233educations
eructations1347233eructations
evocations15259873evocations
fabrications1945923fabrications
factions133013063f_ac_tions
fasciations1646263fasciations
fellations1338063fellations
fetations12511383f_etations
fictions132410743f_ic_tions
figurations1545083figur_ations
filiations13119093filiations
fixations1936353f_ixations
flections14239213flec_tions
flirtations14104263flirtations
floriations1476913floriations
flotations1366873flotations
foliations1399943foliations
formation1439423formation_
fornications1755393fornications
foundations1543433foundations
fraction1359483f_raction_
fractious1456143f_ractious
frictions1448033f_rictions
fruitions12106113f_ruitions
fumigations1744923fumigations
function1337843func_tion_
furcates1339883furcat__es
gustations1147233gustations
guttations1145593guttations
gyrations1336923gyr_ations
infuriations1547443infuriations
junctions1835943junc_tions
laureations1145573laureations
locations112512743_locations
lubrications1645733lubrications
lunations9310723lu_nations
luxations1637273lu_xations
mutations111211453mu_tations
narrations1038943narrations
nervations1359483nervations
nunnations1095903nunnations
nutations91411763nu_tations
obfuscations1951893obfuscations
orations81515803_or_ations
placations1438583placations
plications14310493plications
pulsations1236373pulsations
punctations1585353punctations
pupations1338123pu_pations
purgation1247393purgation_
quotations19146283quotations
rations74123433__r_ations
rubrications1646263rubrications
ructions102811683ru_c_tions
ruinations1039603ruinations
seriations10316683seriations
serrations10313103serrations
striations10312793striations
sublations12410113sublations
suctions103012903su_c_tions
sudations1039903su_dations
sulcation11710733sulcation_
sulfations13107813sulfations
summations1456783summations
tarnations1038903tarnations
tractions11511623_tractions
trifurcations1852863trifurcations
truncations1344763truncations
unctions1039733_unc_tions
urinations10310693_urinations
urtications1348033_urtications
usurpations1343473usurpations
vacations141910553_vacations
variations13310773variations
vernations13310333vernations
vocations141911423_vocations

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603976.26622439.0
3Display Results97970.0462108.7
 (SQL Overall)178691976.71826598.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.