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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
spelt7543019(None) 
pelt67651081_pelt
smelt74726781smelt
spell75020301spell
spelts84614641spelts
speltz174010111speltz
spent75532831spent
spilt75532221spilt
aspect10612822aspect
belt65754032_belt
celt65646712_celt
delt57855272_delt
dwelt94316522dwelt
felt75146932_felt
gelt56448012_gelt
kelt85343192_kelt
knelt94617682knelt
melt65752892_melt
peat65967932_peat
pele65539552_pele
pelf97031452_pelf
pelts76128812_pelts
pent66559072_pent
pert66759322_pert
pest65555292_pest
pet56477302_pe_t
respelt9312142respelt
salt45758522s_alt
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
shalt85534482shalt
sheet84836952sheet
shelf115221112shelf
shell84424122shell
shelta93111782shelta
shelty124011542shelty
shent85933492shent
silt46558192s_ilt
skeet95429182skeet
skell94915832skell
skelm114211282skelm
skelp114211422skelp
sleet55639132sleet
slept75728102slept
smalt74729332smalt
smell74916232smell
smelts85412772smelts
smolt74824162smolt
snell54517302snell
spait75631602spait
spale74929212spale
spall74919302spall
spat66548522sp_at
speak114618672speak
spean74620512spean
spear75821062spear
spec85821972spe_c
speck135115652speck
specs96916672specs
sped76031492spe_d
speed85526622speed
speel74420762speel
speels85116392speels
speer74623902speer
speil75618642speil
speils84116222speils
speir75315362speir
spells84617682spells
spelter94113702spelter
spend85619332spend
sperm93216012sperm
spew95421872spe_w
spews105015922spews
spiel74623912spiel_
spiels85317952spiels
spile75230082spile
spill74821162spill
spilth11469732spilth
spirt75032952spirt
spit65545082sp_it
splat76129342splat
splent84720192splent
split75729012split
spoilt85016592spoilt
sport75935982sport
spot65540682sp_ot
spout75029632spout
sprat76635972sprat
sprent84522382sprent
sprit76736402sprit
spurt77227982spurt
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.0931921408.6
2DLD Change Limit538001171.64032804.9
3Display Results1171170.0462543.5
 (SQL Overall)1786911171.779100444.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.