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

143 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
ciliation11111249(None) 
ciliations121111001ciliations
filiation121110241filiation
citation10314362ci_tation
collation11313992collation
dilation92215462dil_ation
filiations13119092filiations
foliation121110792foliation
illation8311942_illation
siltation939212siltation
vitiation1239562vitiation
ablation10312433abl_ation
acclimation17127093acclimation
acylation1448653acyl_ation
affiliation1744853affiliation
alation72920553_al_ation
aviation11312743_aviation
bilection13156803bilection
bilocation1446123bilocation
calcination1548903calcination
calibration1545993calibration
capitation14311363capitation
carnation11312943carnation
caseation1199513caseation
cassation1197913cassation
cation83925503c___ation
caudation1269993caudation
causation1199523causation
cavitation1549133cavitation
cessation1176853cessation
chelation1439963chelation
ciliate9514603ciliat__e
ciliated11510953ciliat_ed
ciliately1443953ciliately
ciliates10413453ciliat_es
citations11312503ci_tations
civilisation1753943civilisation
civilization2647613civilization
clarion9311663c_l_arion
clavation1447003clavation
coalition1148703coali_tion
cogitation13410083cogitation
cognation12310753cognation
coition9314313c_oi_tion
colistin10410553colisti_n
collations12312853collations
colligation1457443colligation
collimation1557573collimation
coloration12913183coloration
conation101420883c_onation
conciliation1648233conciliation
connation11314263connation
creation102816513c_reation
cremation13511643cremation
crenation11412923crenation
crimination1549413crimination
culmination1557643culmination
cultivation16116413cultivation
cyclization2746413cyclization
delation92318083del_ation
deviation13312393deviation
dictation12810563dictation
dilatation1147393dilatation
dilations102614453dil_ations
dilution9239143dil_ution
divination14139233divination
elation73620453_el_ation
epilation11312963epil_ation
expiation18710423expiation
facilitation1746573facilitation
fellation1238843fellation
filiating1339243filiating
filtration1346433filtration
fixation1837073fi_xation
foliations1399943foliations
gelation93014433gel_ation
halation11313853hal_ation
himation1339753hi_mation
humiliation1675193humiliation
ideation9310493_ideation
illations9311393_illations
imitation11510853_imitation
initiation10412103initiation
iodation9310383_iodation
laciniation1346633laciniation
lallation939493lallation
libation102411363li_bation
libration111510163libration
ligation92313093li_gation
limitation1249153limitation
lineation9310763lineation
liquation1846553liquation
litigation1148173litigation
mediation12312293mediation
migration12179703migration
mitigation1348643mitigation
nictation1189273nictation
nidation9410583ni_dation
nitration9313443nitration
oblation1039863obl_ation
obligation1346783obligation
obviation1446093obviation
oscillation1345493oscillation
palliation1248503palliation
palmation13310223palmation
palpation1339073palpation
peltation11312963peltation
pinnation1138013pinnation
pixilation1945913pixilation
plication13311683plication
pulsation1137143pulsation
radiation10313393radiation
relation82619773rel_ation
reliction11310693reliction
salivation1349813salivation
saltation9312003saltation
salvation1239293salvation
satiation9313433satiation
scalation11311073scal_ation
seriation9318063seriation
sibilation12128773sibilation
siltations1038553siltations
sinuation9310413sinuation
situation949423situation
solation8916153sol_ation
solvation1237773solvation
spoliation1248423spoliation
striation9313483striation
sulcation11710733sulcation
sulfation1288783sulfation
titivation1347033titivation
titration9310543titration
utilization2049683utilization
vacillation1645313vacillation
validation1448413validation
vallation1239743vallation
valuation1249973valuation
variation12312393variation
vibration14138203vibration
violation1238443violation
visitation1348593visitation
vitiations1338743vitiations
volition1179173voli_tion

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit1486411437.62319499.0
3Display Results1431430.0632269.8
 (SQL Overall)1786911438.13921954.9
 
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.