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 “smelt” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
smelt7472678(None) 
melt65752891_melt
smalt74729331smalt
smell74916231smell
smelts85412771smelts
smolt74824161smolt
spelt75430191spelt
ament76036542ament
belt65754032_belt
celt65646712_celt
delt57855272_delt
dwelt94316522dwelt
felt75146932_felt
gelt56448012_gelt
kelt85343192_kelt
knelt94617682knelt
malt66254812_malt
meat66359602_meat
meet65350552_meet
mel56047482_mel_
meld75830472_meld
mell64935612_mell
mels65941532_mels
melts74930102_melts
melty104918362_melty
met56072432_me_t
milt65455812_milt
molt66356162_molt
omelet8317072omelet
pelt67651082_pelt
remelt85123122remelt
resmelt9411772resmelt
salt45758522s_alt
samlet84126562samlet
sault55834962sault
scent75831622scent
seat47575562s_eat
sect67443622s_ect
seel45042982seel_
seels55632822seels
seely84522632seely
sel38253322s_el_
self75138292s_elf
sell45840612s_ell
sels46345982s_els
sent46963012s_ent
sept65844362s_ept
set36681252s_e_t
sett45949052s_ett
sext117338092s_ext
shalt85534492shalt
sheet84836962sheet
shelf115221112shelf
shell84424122shell
shelta93111792shelta
shelty124011552shelty
shent85933502shent
silt46558192s_ilt
skeet95429182skeet
skell94915832skell
skelm114211292skelm
skelp114211422skelp
sleet55639132sleet
slept75728102slept
small74016262small
smalti84111192smalti
smalto84410282smalto
smalts85214892smalts
smart75834092smart
smear74416392smear
smeek114912352smeek
smells83914742smells
smelly114110362smelly
smelted10399092smelted
smelter93311912smelter
smerk115412722smerk
smew95017732sme_w
smews104612292smews
smile74823922smile
smit65138412sm_it
smolts84411882smolts
smut66629782sm_ut
snell54517302snell
spell75020302spell
spelts84614642spelts
speltz174010122speltz
spent75532832spent
spilt75532222spilt
stela54019042stela
stele55026842stele
stent55634512stent
stet45947322ste_t
stilt54831982stilt
suet46754822sue_t
svelte9319752svelte
sweat85628402sweat
sweet85330522sweet
swell84815982swell
swept105720602swept
welt75547862_welt

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001001.40638264.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.732103170.3
 
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.