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

260 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
dilation9221546(None) 
delation92318081delation
dilations102614451dilations
dilution9239141dilution
ablation10312432ablation
adulation10311012adulation
alation72920552_alation
ciliation111112492ciliation
citation10314362citation
dealation10313002dealation
deflation13310652deflation
delations102616592delations
deletion92011972deletion
depilation13312032depilation
diatron839282di_atron
dictation12810562dictation
diction102313052di_ction
dilatation1147392dilatation
dilating102714902dilating
dilative1239522dilative
dilator82712782dilat_or
dilutions10248582dilutions
diluvion12215412diluvion
donation91513782donation
dotation91412732dotation
duration9312692duration
elation73620452_elation
epilation11312962epilation
filiation121110242filiation
fixation1837072fixation
gelation93014432gelation
halation11313852halation
himation1339752himation
ideation9310492ideation
illation8311942illation
libation102411362libation
ligation92313092ligation
nidation9410582nidation
oblation1039862oblation
relation82619772relation
siltation939212siltation
solation8916152solation
violation1238442violation
abdication1548223abdication
ablations11311513ablations
ablution1047223ablution
acylation1448653acylation
admiration1347733admiration
adnation9310783adnation
adoration10311313adoration
adulations11310123adulations
aeration8319933aeration
agitation10311223agitation
agnation9311723agnation
alations82518893_alations
animation11313683animation
aviation11312743aviation
bilection13156803bilection
billion92212173bil_lion
bilocation1446123bilocation
cation83925503__cation
chelation1439963chelation
ciliations121111003ciliations
citations11312503citations
clarion9311663_clarion
collation11313993collation
conation101420883conation
creation102816513creation
dalapon1044893dala_pon
dalmatian1244643dalmatian
dalton7311273dal_t_on
damnation1238403damnation
darnation1039823darnation
dealations11311373dealations
decimation15411623decimation
dedication14311963dedication
deflations1439713deflations
delating103119603delating
delator83015023delat_or
delegation1238883delegation
deletions102610933deletions
delusion937433delusion
demotion1169073demotion
dentation10315243dentation
depilations14310903depilations
depletion1256663depletion
derivation14712783derivation
desolation11311403desolation
deviation13312393deviation
devotion1256763devotion
diamin9312523di_ami_n
diatom939453di_at_om
diatrons939613di_atrons
diazin1639163di_azi_n
diazinon1842203di_azinon
dictations1389703dictations
dictions111812673di_ctions
digestion1146573digestion
dilatant948203dilatant
dilatate947773dilatate
dilatations1246413dilatations
dilatator1044143dilatator
dilate73220693dilat__e
dilated93115823dilat_ed
dilater83515653dilat_er
dilaters92513063dilaters
dilates83220663dilat_es
dilators93213193dilators
dilatory12279273dilatory
diluting10248983diluting
dilutive1255373dilutive
dilutor8256013dilut_or
diluvian12194663diluvian
diluvions13224443diluvions
direction1289783direction
dislocation14147503dislocation
disrelation1248813disrelation
distain8313783distai_n
disunion956113disunion
divagation15104373divagation
divination14139233divination
division1266683division
domination13712373domination
donations101112353donations
dotations101411633dotations
dubitation1377333dubitation
durations10311463durations
dynatron1243623dynatron
edition8310853edi__tion
education12310203education
elations83719123_elations
elution72913823_elution
emulation11312393emulation
enation73419233_enation
epilations12311713epilations
equation17310483equation
etiolation1048533etiolation
fellation1238843fellation
fetation11613143fetation
fiction122010733fi_ction
filarian1148313filarian
filiations13119093filiations
filtration1346433filtration
fixations1936353fixations
flatiron1144623_flatiron
foliation121110793foliation
gelatin83514733gelati_n
gelations102513093gelations
gigaton946343gigat_on
gyration1237763gyration
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
imitation11510853imitation
inaction1039623_inaction
indication13312033indication
inflation12311093inflation
iodation9310383iodation
iodination1159983iodination
isatin6412213_isati_n
isolation9311643isolation
jillion14188933jil_lion
jubilation1946053jubilation
kation104315683__kation
kiloton1196313kilot_on
lallation939493lallation
latino64120473__latino
lavation1139973lavation
laxation1538423laxation
legation92412933legation
libations112510443libations
libration111510163libration
ligations102111993ligations
lineation9310763lineation
liquation1846553liquation
lobation102110553lobation
location102113913location
lotion65716523__lotion
lunation8311923lunation
luxation1538233luxation
malathion1444513malathion
mediation12312293medi_ation
medication15411173medication
meditation13410743meditation
migration12179703migration
million91813143mil_lion
modulation13147933modulation
mutation101412883mutation
mutilation1249753mutilation
natation81513933natation
nation64322803__nation
negation92913023negation
nictation1189273nictation
nidations1039213nidations
nitration9313443nitration
nodulation11127993nodulation
notation81414603notation
novation111710013novation
nutation81513103nutation
oblations1139373oblations
oration71617713_oration
ordination1149413ordination
ovation101510023_ovation
ovulation1238983ovulation
oxidation1746323oxidation
palmation13310223palmation
palpation1339073palpation
peltation11312963peltation
pillion92011703pil_lion
pinnation1138013pinnation
pixilation1945913pixilation
platoon938953_platoon
plication13311683plication
potation101716783potation
privation14311173privation
pulsation1137143pulsation
pupation1269503pupation
radiation10313393radi_ation
ration64226013__ration
reflation12412333reflation
relations92418333relations
rogation91612053rogation
rotation81615453rotation
ruination9311273ruination
saltation9312003saltation
salvation1239293salvation
scalation11311073scalation
sedation9312453sedation
sibilation12128773sibilation
siltations1038553siltations
simulation1269583simulation
sinuation9310413sinuation
situation949423situation
solations9814623solations
solution889593solution
solvation1237773solvation
station72717243_station
sublation11311013sublation
sudation9310803sudation
sulcation11710733sulcation
sulfation1288783sulfation
taxation1537993taxation
titration9310543titration
ululation938093ululation
undulation1147103undulation
urination9312173urination
vacation131911893vacation
vallation1239743vallation
valuation1249973valuation
venation11513503venation
vexation1838783vexation
vibration14138203vibration
violations1337963violations
vitiation1239563vitiation
vocation132311983vocation
volition1179173volition
volution1198603volution
zillion16188773zil_lion
zonation171410723zonation

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 Filter1786911461620.626285448.9
2DLD Change Limit1461622608.03018202.0
3Display Results2602600.1102363.6
 (SQL Overall)1786912608.76620384.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.