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

280 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
solation891615(None) 
isolation9311641isolation
solations9814621solations
solution889591solution
solvation1237771solvation
ablation10312432ablation
alation72920552_alation
collation11313992collation
conation101420882conation
delation92318082delation
desolation11311402desolation
dilation92215462dilation
donation91513782donation
dotation91412732dotation
elation73620452_elation
foliation121110792foliation
gelation93014432gelation
halation11313852halation
illation8311942illation
insolation10410212insolation
iodation9310382iodation
isolations10310692isolations
lobation102110552lobation
location102113912location
notation81414602notation
novation111710012novation
oblation1039862oblation
oration71617712_oration
ovation101510022_ovation
potation101716782potation
relation82619772relation
rogation91612052rogation
rotation81615452rotation
saltation9312002saltation
salvation1239292salvation
scalation11311072scalation
sedation9312452sedation
siltation939212siltation
solanin7311942solani_n
solatia7312252solati_a
solating9315592solating
solatium1067612solatium
solion6616382sol__ion
soliton7410232solit_on
solutions988882solutions
solvations1336832solvations
sorption1037512sorption
spoliation1248422spoliation
station72717242s_tation
sublation11311012sublation
sudation9310802sudation
sulcation11710732sulcation
sulfation1288782sulfation
violation1238442violation
vocation132311982vocation
volition1179172volition
volution1198602volution
zonation171410722zonation
ablations11311513ablations
ablution1047223ablution
abolition1147053abolition
absolution1244403absolution
acylation1448653acylation
adnation9310783adnation
adoration10311313adoration
adulation10311013adulation
aeration8319933aeration
agnation9311723agnation
alations82518893_alations
aviation11312743aviation
avocation14168993avocation
bolection13117673bolection
cation83925503__cation
chelation1439963chelation
ciliation111112493ciliation
citation10314363citation
clarion9311663_clarion
coaction12310773coaction
coalition1148703coalition
cognation12310753cognation
coition9314313co_ition
collations12312853collations
coloration12913183coloration
conations111318903conations
conflation15412083conflation
connation11314263connation
consolation13410983consolation
cooption1288343cooption
copatron1246753copatron
copulation141111953copulation
creation102816513creation
dealation10313003dealation
deflation13310653deflation
delations102616593delations
deletion92011973deletion
desolations12310593desolations
dilations102614453dilations
dilution9239143dilution
donations101112353donations
dotations101411633dotations
duration9312693duration
elations83719123_elations
elution72913823_elution
emulation11312393emulation
enation73419233_enation
epilation11312963epilation
equation17310483equation
escalation1248873escalation
etiolation1048533etiolation
evocation142010293evocation
evolution12117093evolution
exsolution1743763exsolution
fellation1238843fellation
fetation11613143fetation
filiation121110243filiation
fixation1837073fixation
flatiron1144623_flatiron
flotation1267813flotation
folacin1238053folaci_n
foliations1399943foliations
formation1439423formation
gelatin83514733gelati_n
gelations102513093gelations
gyration1237763gyration
halations12312393halations
himation1339753himation
ideation9310493ideation
illations9311393illations
immolation1446103immolation
inflation12311093inflation
insolations1149183insolations
insulation10311663insulation
iodations1039113iodations
isolating1039743isolating
isolator847533isolat_or
kation104315683__kation
lallation939493lallation
latino64120473__latino
lavation1139973lavation
laxation1538423laxation
legation92412933legation
libation102411363libation
ligation92313093ligation
lobations11219613lobations
lobulation1247233lobulation
locations112512743locations
locution10227663locution
lotion65716523__lotion
lunation8311923lunation
luxation1538233luxation
malathion1444513malathion
modulation13147933modulation
monition10311723monition
morulation12148903morulation
motion85217553mo__tion
mutation101412883mutation
natation81513933natation
nation64322803__nation
negation92913023negation
nidation9410583nidation
nodulation11127993nodulation
nonaction1149443nonaction
notations91512973notations
notion64516583no__tion
novations12139003novations
nutation81513103nutation
oblations1139373oblations
olfaction1464233_olfaction
option83612713_o_ption
orations81515803_orations
osculation1249673osculation
ovations11149263_ovations
ovulation1238983ovulation
ozonation1845673ozonation
palmation13310223palmation
palpation1339073palpation
peltation11312963peltation
phonation1439393phonation
platoon938953_platoon
polaron939843pola_ron
pollution1146003pollution
population14810023population
portion9615493po_rtion
position10912193position
potations111615073potations
potion84519573po__tion
probation13412183probation
pronation11415703pronation
proration11415983proration
pulsation1137143pulsation
pupation1269503pupation
quotation18146973quotation
ration64226013__ration
reflation12412333reflation
relations92418333relations
resolution1097733resolution
rogations101510823rogations
rotations91613843rotations
sabaton937713sabat_on
sacaton938993sacat_on
salivation1349813salivation
saltations10310623saltations
salutation1048903salutation
salvations1338133salvations
sanction1049533sanction
satiation9313433satiation
satin55935223s__ati_n
scalations1239783scalations
scallion1046793scallion
section92515663s_ection
sedations10311253sedations
sedition939333sedition
selection11311273selection
sensation9510583sensation
seriation9318063seriation
serration9414073serration
sibilation12128773sibilation
siltations1038553siltations
simulation1269583simulation
sinuation9310413sinuation
situation949423situation
slain54923573s_la_i_n
slatier74016813s_latier
slating83724653s_lating
solacing11310133solacing
solan55328153sola___n
solanine8311533solanine
solanins8310513solanins
solano65314183sola_no_
solanos74412853sola_nos
solaria7312493solari_a
solarise8512543solarise
solarism10810383solarism
solarium1078263solarium
solarize17511473solarize
solate64526073solat__e
solated83618023solat_ed
solates73523853solat_es
solions7513753sol__ions
solitons849593solit_ons
solmization2247323solmization
solon55026133sol___on
solstice1047223solstice
solvating1336443solvating
somatic111916473somati_c
sonatina849073sonatina
sonatine8313323sonatine
sonication12411183sonication
sorptions1137123sorptions
sortition946703sortition
spallation1247023spallation
spoliations1347693spoliations
sporulation1346403sporulation
stallion837523stallion
statin63921473s_tati_n
stations82415223s_tations
stiction1038823stiction
striation9313483striation
suasion739363s_uasion
sublations12410113sublations
suction93713043s_uction
sudations1039903sudations
sulcations1289583sulcations
sulfations13107813sulfations
summation1347803summation
taxation1537993taxation
toleration1048963toleration
ululation938093ululation
vacation131911893vacation
vallation1239753vallation
valuation1249973valuation
venation11513503venation
vexation1838783vexation
violations1337963violations
vocations141911423vocations
volatile1146433volatile
volitions1288663volitions
volutin1098103voluti_n
volutions12108393volutions
zonations18139313zonations

Search took 8 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.453394461.4
2DLD Change Limit1461622807.15620425.1
3Display Results2802800.1232276.4
 (SQL Overall)1786912807.73223110.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.