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

132 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
scalation1131107(None) 
escalation1248871escalation
scalations1239781scalations
acylation1448652acylation
alation72920552__alation
dealation10313002dealation
escalations1347662escalations
halation11313852_halation
osculation1249672osculation
saltation9312002s_altation
salvation1239292s_alvation
scallion1046792scal_lion
solation8916152s_olation
spallation1247022spallation
sublation11311012sublation
ablation10312433_ablation
actuation11310333actuation
acylations1547603acylations
adulation10311013adulation
alations82518893__alations
calathos1347523_calathos
calutron1045553_calutron
caption113513693_ca_ption
carnation11312943_carnation
caseation1199513_caseation
cassation1197913_cassation
cation83925503_c__ation
caudation1269993_caudation
causation1199523_causation
caution93013523_ca_ution
chalazion23113723chalazion
chelation1439963chelation
ciliation111112493_ciliation
citation10314363_citation
clarion9311663_c_larion
clavation1447003clavation
coalition1148703coalition
collation11313993collation
conation101420883_conation
creation102816513_creation
dealations11311373dealations
deflation13310653deflation
delation92318083_delation
dilation92215463_dilation
elation73620453__elation
emanation11910783emanation
emulation11312393emulation
epilation11312963epilation
escalating1347083escalating
escalator1145683escalat_or
evaluation1358183evaluation
exaltation1748493exaltation
excavation2245433excavation
exhalation2046653exhalation
fellation1238843fellation
gelation93014433_gelation
gradation11107713gradation
halations12312393_halations
illation8311943_illation
inflation12311093inflation
inhalation13107663inhalation
isolation9311643isolation
jactation1838143jactation
lactation11310813lactation
lallation939493lallation
lavation1139973_lavation
laxation1538423_laxation
maculation14510983maculation
malathion1444513_malathion
natation81513933_natation
oblation1039863_oblation
oscillation1345493oscillation
osculations1348373osculations
ovulation1238983ovulation
palmation13310223_palmation
palpation1339073_palpation
peculation14311993peculation
placation1339773placation
planation11310123planation
reescalation1464083reescalation
reflation12412333reflation
relation82619773_relation
sabaton937713s_abat_on
sacaton938993s_acat_on
sacculation1547843sacculation
salivation1349813s_alivation
saltations10310623s_altations
salutation1048903s_alutation
salvations1338133s_alvations
sanction1049533s_anction
satiation9313433satiation
scalado10276473scala_do_
scalados11276083scala_dos
scallions1145783scal_lions
scansion1045693sca_nsion
scarlatina1294053scarlatina
scullion1065633scul_lion
sedation9312453s_edation
sensation9510583sensation
separation12510433separation
seriation9318063seriation
serration9414063serration
sibilation12128773sibilation
siltation939213siltation
simulation1269583simulation
sinuation9310413sinuation
situation949423situation
solations9814623s_olations
solution889593s_olution
solvation1237773solvation
spallations1356103spallations
speculation1547543speculation
spiculation1547033spiculation
spoliation1248423spoliation
squamation2153533squamation
stagflation1553143stagflation
stagnation1145543stagnation
stallion837513stal_lion
starvation1345493starvation
station72717243s__tation
striation9313483striation
sublations12410113sublations
sudation9310803s_udation
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
taxation1537993_taxation
ululation938093ululation
vacation131911893_vacation
vallation1239743vallation
valuation1249973_valuation
violation1238443violation

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.780229091.0
2DLD Change Limit1486411327.98318619.7
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.82620246.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.