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

140 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
ciliations12111100(None) 
ciliation111112491ciliation_
filiations13119091filiations
citations11312502ci_tations
collations12312852collations
dilations102614452dil_ations
filiation121110242filiation_
foliations1399942foliations
illations9311392_illations
siltations1038552siltations
vitiations1338742vitiations
ablations11311513abl_ations
acclimations18146293acclimations
acylations1547603acyl_ations
affiliations1844183affiliations
alations82518893_al_ations
aviations12311553_aviations
bilections14136503bilections
bilocations1545293bilocations
calcinations1647933calcinations
calibrations1645153calibrations
capitations1549853capitations
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
cations94524143c___ations
caudations13108223caudations
causations1268143causations
cavitations1647843cavitations
cessations1256473cessations
chelations1539073chelations
ciliates10413453ciliat__es
citation10314363ci_tation_
civilisations1853643civilisations
civilizations2747273civilizations
clarions10310493c_l_arions
clavations1546183clavations
coalitions1247923coali_tions
cogitations1448903cogitations
cognations1339593cognations
coitions10312853c_oi_tions
colistins1149233colisti_ns
collation11313993collation_
colligations1556843colligations
collimations1656873collimations
colorations13911893colorations
conations111318903c_onations
conciliations1747203conciliations
connations12312943connations
creations112614543c_reations
cremations14410713cremations
crenations12511693crenations
criminations1648063criminations
culminations1646533culminations
cultivations1745593cultivations
cyclizations2845753cyclizations
delations102616593del_ations
deviations14311163deviations
dictations1389703dictations
dilatations1246413dilatations
dilation92215463dil_ation_
dilutions10248583dil_utions
divinations15128413divinations
elations83719123_el_ations
epilations12311713epil_ations
expiations1959663expiations
facilitations1845763facilitations
fellations1338063fellations
filiating1339253filiati_ng
filtrations1445623filtrations
fixations1936353fi_xations
foliation121110793foliation_
gelations102513093gel_ations
halations12312393hal_ations
himations1438803hi_mations
humiliations1784553humiliations
ideations1039903_ideations
illation8311943_illation_
imitations1259963_imitations
initiations11410723initiations
iodations1039113_iodations
laciniations1445913laciniations
lallations1038743lallations
libations112510443li_bations
librations12149063librations
ligations102111993li_gations
limitations1348183limitations
lineations1039543lineations
liquations1945623liquations
litigations1247333litigations
mediations13310983mediations
migrations13168683migrations
mitigations1447623mitigations
nictations1278313nictations
nidations1039213ni_dations
nitrations10312033nitrations
oblations1139373obl_ations
obligations1446143obligations
obviations1545463obviations
oscillations1445123oscillations
palliations1347723palliations
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
pinnations1236883pinnations
pixilations2045333pixilations
plications14310493plications
pulsations1236373pulsations
radiations11311923radiations
relations92418333rel_ations
relictions12310023relictions
salivations1448733salivations
saltations10310623saltations
salvations1338133salvations
satiations10312113satiations
scalations1239783scal_ations
seriations10316683seriations
sibilations13127933sibilations
siltation939213siltation_
sinuations1039413sinuations
situations1038433situations
solations9814623sol_ations
solvations1336833solvations
spoliations1347693spoliations
striations10312793striations
sulcations1289583sulcations
sulfations13107813sulfations
titivations1446263titivations
titrations1039173titrations
utilizations2148893utilizations
vacillations1744883vacillations
validations1547243validations
vallations1339093vallations
valuations1348783valuations
variations13310773variations
vibrations15157373vibrations
violations1337963violations
visitations1447673visitations
vitiation1239563vitiation_
volitions1288663voli_tions

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.420425454.8
2DLD Change Limit1406031406.31322272.0
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.79626293.6
 
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.