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

143 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
shell8442412(None) 
hell75637891_hell
sell45840611s_ell
shall85024051shall
sheal84927701sheal
shelf115221111shelf
shells94319521shells
shelly124414471shelly
sheol84318371sheol
shill85325331shill
skell94915831skell
smell74916231smell
snell54517301snell
spell75020301spell
swell84815981swell
ahull84010312ahull
bell66237182_bell
cell65031722_cell
chela103916802chela
chill105619872chill
dell56938202_dell
dwell9519852dwell
ell36735682__ell
fell76833072_fell
ghyll1246322ghyll
hall75741162_hall
heal75645692_heal
heel75034222_heel
heil76328932_heil
held85330402_held
hello86522982_hello
hells85032042_hells
helm95530022_helm
helo75332852_helo
help95328922_help
herl75834552_herl
hill76439492_hill
hull75428782_hull
jell117125872_jell
knell94210922knell
kvell12436692kvell
mell64935612_mell
quell144311432quell
sall44544682s_all
scall74420372scall
scull75315762scull
seal45654372s_eal
seel45042982s_eel
seels55632822seels
seely84522632seely
sel38253322s_e_l
self75138292s_elf
selle54428312s_elle
sells55134432s_ells
sels46345982s_els
shale85332832shale
shalt85534492shalt
shaly114322862shaly
shaul85418102shaul
shawl116217572shawl
she66837692she__
shea76031572she_a
sheaf115424122sheaf
sheals94420642sheals
shear85424832shear
sheas86331792sheas
shed86536152she_d
sheds96122702sheds
sheen85023312sheen
sheep105321522sheep
sheer84726892sheer
sheet84836962sheet
sheik122514662sheik
sheila969842sheila
shekel1338382shekel
shellac1236692shellac
shelled113815082shelled
sheller103515882sheller
shelta93111792shelta
shelty124011552shelty
shelve124012762shelve
shelvy15377862shelvy
shend94719972shend
shent85933502shent
sheols94614162sheols
sheqel1846522sheqel
sherd96321152sherd
shes75734352she_s
shew108030762she_w
shewn115715702shewn
shews115924712shews
shiel811023772shiel
shield106212972shield
shiels95418922shiels
shills94519612shills
shily115222012shily
shlep104914832shlep
shoal83920272shoal
shool84523152shool
shorl84720252shorl
shrill94712302shrill
shtetl936442shtetl
shul75823152sh_ul
shuln84713112shuln
shuls85319712shuls
shyly144811572shyly
sill45545152s_ill
skells105013782skells
skelm114211292skelm
skelp114211422skelp
skill94316722skill
skull94812032skull
small74016262small
smells83914742smells
smelly114110362smelly
smelt74726782smelt
snells64614202snells
spall74919302spall
speel74420762speel
speil75618642speil
spells84617682spells
spelt75430192spelt
spill74821162spill
stall54722352stall
steal56125472steal
steel55721992steel
stela54019042stela
stele55026842stele
stella63612972stella
still54922082still
stull54916272stull
swells93913982swells
swill83417372swill
tell44934702_tell
thill85918732thill
unshell1047112unshell
well75832042_well
wheal115716182wheal
wheel115515332wheel
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
yell76028322_yell

Search took 4 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.610292936.1
2DLD Change Limit538001432.29623432.1
3Display Results1431430.0801787.5
 (SQL Overall)1786911432.98659842.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.