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

210 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
sulfates1131079(None) 
sulfate10311651sulfate_
sulfated1238831sulfated
sulfites1139901sulfites
bisulfates15143222bisulfates
disulfates14145362disulfates
pulsates1048812pulsates
slates64934062s_l_ates
solates73523852sol_ates
solvates11249672solvates
soulmates1147072soulmates
sublates10315002sublates
sufflates1546032sufflates
sulcate9314422sulcate_
sulcated11310372sulcated
sulfas9311562sulfa__s
sulfatase1242492sulfatase
sulfatases1352412sulfatases
sulfides1238052sulfides
sulfite10310472sulfite_
sulfonates1344572sulfonates
sulfones1147682sulfones
sulfurates1345762sulfurates
sullages939972sullages
sulphates1466172sulphates
summates122610492summates
surfaces1338672surfaces
vulgates12237232vulgates
ablates92416903abl_ates
adulates9311913adul_ates
alates64833963_al_ates
bisulfate14143653bisulfate_
bisulfites15152663bisulfites
bulkages1535273bulkages
bullaces12299433bullaces
bullate93415073bullate_
califates14310113califates
ciliates10413453ciliates
collates103019143collates
culottes1076293culottes
curates95323833cu_rates
deflates123013943deflates
delates83526283del_ates
dilates83220663dil_ates
disulfate13145713disulfate_
elates65032363_el_ates
eluates72014683_eluates
emulates10312573emul_ates
fates85139233___fates
fellates11312753fellates
filiates11412663filiates
folates103218453fol_ates
foliates11412753foliates
fullfaces1742633fullfaces
furcates1339883furcates
gallates92815523gallates
gelates83219583gel_ates
humates122813193hu_mates
inflates11512193inflates
insulates9311843insul_ates
isolates8613513isol_ates
kalifates1646133kalifates
luxates1436973lu_xates
malates93522603mal_ates
maleates103316343maleates
mullites10411643mullites
muriates10312083muriates
mutates92215793mu_tates
nucleates1148563nucleates
nutates73214973nu_tates
oblates91913243obl_ates
oleates7417833_oleates
osculates11109393oscul_ates
outdates93114743outdates
outfaces132311393outfaces
outrates82421373outrates
ovulates1148523ovul_ates
palates93624933pal_ates
palpates122613063palpates
plates85432243_pl_ates
pulsate9510233pulsate_
pulsated1136853pulsated
pupates113311433pu_pates
reflates113115663reflates
relates73731433rel_ates
ruinates8311883ruinates
salivates1239293salivates
salutes73716253sal_utes
salvages1238123salvages
sates54949323s___ates
satiates8314633satiates
savates10312953s_avates
sedates83418043s_edates
selenates91611363selenates
selvages1236513selvages
senates73322613s_enates
sensates8511143sensates
serfages1238233serfages
seriates82620673seriates
serrates82617023serrates
silages82514443sil_ages
silanes72517163sil_anes
silicates11311523silicates
simulates1139853simul_ates
sinuates8310963sinuates
situates8310373situates
skates104219403s__kates
slakes104021883s_l_akes
slate55438283s_l_ate_
slated75028313s_l_ated
slater64429183s_l_ater
slaters73123733s_l_aters
slatey95417063s_l_atey
slats55436903s_l_at_s
slaves95023023s_l_aves
sleaves103813203s_leaves
sleazes162810333s_leazes
solaces93116133sol_aces
solate64526073sol_ate_
solated83618023sol_ated
solfeges1244083solfeges
solutes73515263sol_utes
solvate102710213solvate_
solvated12237443solvated
sorbates10311103sorbates
soulmate1047193soulmate_
spates85028173s__pates
splakes1349673spl_akes
splats84817303spl_at_s
spoliates1138543spoliates
squamates2045593squamates
states64337083s__tates
stomates10313343stomates
striates83417083striates
subbases1239063subbases
subcastes1387493subcastes
subcutes1238583subcutes
subfiles131710723subfiles
subfixes20207493subfixes
subframes1645853subframes
sublate9315363sublate_
sublated11311503sublated
subleases1148653subleases
sublimates1447173sublimates
subraces12313033subraces
subsales10310123subsales
subsites10312783subsites
substates111410333substates
sucrases10310253sucrases
suffaris1445083suffaris
suffices16208183suffices
suffixes21196353suffixes
sufflate1456183sufflate_
sufflated1644623sufflated
suffocates1843253suffocates
suffrages1644383suffrages
suffuses1435833suffuses
suites63727403su__ites
suldans8299723sulda_ns
sulfa8313923sulfa___
sulfating1338063sulfating
sulfation1288783sulfation
sulfations13107813sulfations
sulfide1138103sulfide_
sulfids1137293sulf_ids
sulfitic1345263sulfitic
sulfonate1245013sulfonate_
sulfonated1443903sulfonated
sulfone1037483sulfone_
sulfurate1246443sulfurate_
sulfurated1444733sulfurated
sulfured1236113sulfured
sulfuret1149273sulfuret
sulfurets1244653sulfurets
sulfurs1037343sulf_urs
sulkies114315763sul_kies
sullage859913sullage_
sullies74122233sul_lies
sulphate1346643sulphate_
sulphated1544723sulphated
sulphites1445683sulphites
sultanas8237153sultanas
sultanates1045233sultanates
sultaness945613sultaness
sultans72411833sulta_ns
summate113611663summate_
summated13298833summated
sunbathes1444113sunbathes
sunbaths1344383sunbaths
sundaes8313093sunda_es
supinates1139553supinates
surbases10310003surbases
surface1238653surface_
surfaced1436063surfaced
surfacer1345663surfacer
surfacers1444323surfacers
suricates11311743suricates
surnames1037273surnames
surtaxes1536513surtaxes
sylvites14225843sylvites
toluates8138903toluates
ullages838953_ullages
ululates848433_ululates
updates10329793_updates
uprates93814863_uprates
urates65027763_u_rates
valuates112811203valuates
vulgate11388433vulgate_
vulvate13388323vulvate_
welfares1445543welfares

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.420425454.8
2DLD Change Limit1461622107.06320694.0
3Display Results2102100.0932258.1
 (SQL Overall)1786912107.57623586.5
 
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.