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

83 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
shelf11522111(None) 
self75138291s_elf
sheaf115424121sheaf
shell84424121shell
chef125125622che_f
chela103916802chela
delf85436572_delf
elf66138522__elf
half106238452_half
held85330402_held
hell75637892_hell
helm95530022_helm
helo75332852_helo
help95328922_help
pelf97031452_pelf
seel45042982seel_
seels55632822seels
seely84522632seely
seif75638732s_eif
sel38253322s_el_
selfs85220242s_elfs
sell45840612s_ell
sels46345982s_els
serf76340112s_erf
shale85332832shale
shall85024052shall
shalt85534492shalt
shaly114322862shaly
she66837692she__
shea76031572she_a
sheafs124912882sheafs
sheal84927702sheal
sheals94420642sheals
shear85424832shear
sheas86331792sheas
shed86536152she_d
sheds96122702sheds
sheen85023312sheen
sheep105321522sheep
sheer84726892sheer
sheet84836962sheet
sheik122514662sheik
sheila969842sheila
shells94319522shells
shelly124414472shelly
shelta93111792shelta
shelty124011552shelty
shelve124012762shelve
shelvy15377862shelvy
shend94719972shend
shent85933502shent
sheol84318372sheol
sheols94614162sheols
sherd96321152sherd
sherif122915242sherif
shes75734352she_s
shew108030762she_w
shewn115715702shewn
shews115924712shews
shiel811023772shiel_
shield106212972shield
shiels95418922shiels
shill85325332shill
shily115222012shily
shlep104914832shlep
shul75823152shul_
shuln84713112shuln
shuls85319712shuls
shyly144811572shyly
skell94915832skell
skelm114211292skelm
skelp114211422skelp
smell74916232smell
smelt74726782smelt
snell54517302snell
spell75020302spell
spelt75430192spelt
stela54019042stela
stele55026842stele
swell84815982swell
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp

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.310576422.6
2DLD Change Limit53800831.48636204.6
3Display Results83830.0136384.6
 (SQL Overall)178691831.80998778.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.