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

106 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
sulfation128878(None) 
sulcation11710731sulcation
sulfations13107811sulfations
pulsation1137142pulsation
saltation9312002saltation
salvation1239292salvation
siltation939212siltation
solation8916152sol_ation
solvation1237772solvation
sublation11311012sublation
sudation9310802su_dation
sulcations1289582sulcations
sulfating1338062sulfating
sulfonation1444262sulfonation
summation1347802summation
ablation10312433abl_ation
adulation10311013adul_ation
alation72920553_al_ation
ciliation111112493ciliation
collation11313993collation
deflation13310653deflation
delation92318083del_ation
dilation92215463dil_ation
duration9312693du_ration
elation73620453_el_ation
emulation11312393emul_ation
exultation1747533exultation
fellation1238843fellation
filiation121110243filiation
foliation121110793foliation
furcation1448353furcation
gelation93014433gel_ation
gustation1047963gustation
guttation1046173guttation
halation11313853hal_ation
illation8311943_illation
inflation12311093inflation
insulation10311663insul_ation
isolation9311643isol_ation
lallation939493lallation
lunation8311923lu_nation
luxation1538233lu_xation
mutation101412883mu_tation
nucleation1245963nucleation
nunnation9126563nunnation
nutation81513103nu_tation
oblation1039863obl_ation
olfaction1464233_olfaction
osculation1249673oscul_ation
ovulation1238983ovul_ation
palmation13310223palmation
palpation1339073palpation
peltation11312963peltation
pulsations1236373pulsations
pupation1269503pu_pation
purgation1247393purgation
quotation18146973quotation
reflation12412333reflation
relation82619773rel_ation
ruination9311273ruination
salivation1349813salivation
saltations10310623saltations
salutation1048903salutation
salvations1338133salvations
satiation9313433satiation
scalation11311073scalation
sedation9312453s_edation
selection11311273selection
sensation9510583sensation
seriation9318063seriation
serration9414063serration
siltations1038553siltations
simulation1269583simul_ation
sinuation9310413sinuation
situation949423situation
solations9814623sol_ations
solution889593sol_ution
solvations1336833solvations
spallation1247023spallation
spoliation1248423spoliation
squamation2153533squamation
station72717243s__tation
striation9313483striation
suasion739363su__asion
sublations12410113sublations
sublimation1557183sublimation
subluxation2043823subluxation
substation1248993substation
suction93713043su__ction
sudations1039903su_dations
suffixation2452863suffixation
suffixion2252243suffixion
suffocation1953373suffocation
suffusion1552773suffusion
sulfatase1242493sulfatase
sulfate10311653sulfat__e
sulfated1238833sulfat_ed
sulfates11310793sulfat_es
sulfitic1345263sulfiti_c
sulfonations1543923sulfonations
summations1456783summations
supination1249883supination
ululation938093_ululation
usurpation1243813usurpation
vallation1239743vallation
valuation1249973valuation

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411067.29620372.9
3Display Results1061060.0631682.5
 (SQL Overall)1786911067.51523777.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.