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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
foliations139994(None) 
filiations13119091filiations
foliation121110791foliation_
ciliations121111002ciliations
collations12312852collations
defoliations1647592defoliations
exfoliations2244782exfoliations
fellations1338062fellations
filiation121110242filiation_
floriations1476912floriations
flotations1366872flotations
foliating1339252foliati_ng
formations1538202formations
solations9814622sol_ations
solvations1336832solvations
spoliations1347692spoliations
volitions1288662voli_tions
ablations11311513abl_ations
abolitions1246653aboli_tions
affiliations1844183affiliations
afflictions1943403afflictions
alations82518893_al_ations
aviations12311553_aviations
bloviations1643753bloviations
bolections14137293bolections
ciliation111112493ciliation_
coalitions1247923coali_tions
cogitations1448903cogitations
cognations1339593cognations
coitions10312853co_i_tions
colistins1149213colisti_ns
collation11313993collation_
colligations1556833colligations
collimations1656873collimations
colorations13911893colorations
conations111318903co_nations
connations12312943connations
defoliation1548313defoliation_
delations102616593del_ations
deviations14311163deviations
dilations102614453dil_ations
dominations14611043dominations
donations101112353do_nations
dotations101411633do_tations
elations83719123_el_ations
epilations12311713epilations
exfoliation2145253exfoliation_
expiations1959663expiations
fasciations1646263fasciations
fellation1238843fellation_
fellatios1245503fellatio_s
fetations12511383f_etations
fictions132410743f__ictions
filiating1339243filiati_ng
filtrations1445623filtrations
fixations1936353f_ixations
flatirons1244483f_l_atirons
flections14239213f_lections
flirtations14104263f_lirtations
floatations1444103floatations
floriation1367793floriation_
flotation1267813flotation_
focalizations2748993focalizations
folacins1337203fol_aci_ns
foliaceous1552553foliaceous
foliates11412753foliat__es
formation1439423formation_
fornications1755393fornications
foundations1543433foundations
frictions1448033f_rictions
fruitions12106113frui_tions
fulminations1745033fulminations
fumigations1744923fumigations
furcations1547533furcations
gelations102513093gel_ations
halations12312393hal_ations
idolizations2247463idolizations
illations9311393_illations
iodations1039113io_dations
iodinations1268843iodinations
ionizations2049893ionizations
isolations10310693isol_ations
lallations1038743lallations
libations112510443__libations
ligations102111993__ligations
lobations11219613lo_bations
locations112512743lo_cations
mediations13310983mediations
monitions11310883moni_tions
motivations1647093motivations
nominations13410533nominations
notations91512973no_tations
novations12139003no_vations
oblations1139363_oblations
obligations1446143obligations
obviations1545463obviations
olfactions1563873_olfactions
orations81515803_o_rations
ovations11149263_o_vations
oxidations1845443_oxidations
palliations1347723palliations
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
plications14310493_plications
pollinations1447233pollinations
pollutions1245433pollutions
positions11811503posi_tions
potations111615073po_tations
pulsations1236373pulsations
radiations11311923radiations
relations92418333rel_ations
relictions12310023relictions
rogations101510823ro_gations
rotations91613843ro_tations
salivations1448733salivations
saltations10310623saltations
salvations1338133salvations
satiations10312113satiations
seriations10316683seriations
siltations1038553siltations
solation8916153sol_ation_
solitons849593soli_t_ons
solmizations2346633solmizations
solutions988883sol_utions
solvation1237773solvation_
sonications1349953sonications
spoliation1248423spoliation_
striations10312793striations
sulcations1289583sulcations
sulfations13107813sulfations
tolerations1158133tolerations
validations1547243validations
vallations1339083vallations
valuations1348783valuations
variations13310773variations
violations1337963viol_ations
vitiations1338743vitiations
vocations141911423vo_cations
volition1179173voli_tion_
volutions12108393vol_utions
zonations18139313zo_nations

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.1561145455.1
2DLD Change Limit1406031426.61021271.3
3Display Results1421420.0602366.7
 (SQL Overall)1786911426.82626178.0
 
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.