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

107 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
unshell104711(None) 
unsell63512541uns_ell
unshells1145921unshells
nutshell1142962nutshell
shell84424122__shell
subshell1344882subshell
unhelm1136862un_helm
unseal63315472uns_eal
unsells73210772uns_ells
unshed10313772unshe_d
unshelled1336572unshelled
unsteel738792unsteel
unwell9349442un_well
upswell1242722upswell
ainsell796393ains_ell
anthill1048203anthill
bandshell1563043bandshell
bonspell1243163bonspell
bushel114513943bushe_l
bushels124110713bushels
dishelm1335833dishelm
dunghill1342173dunghill
eggshell1351043eggshell
enwheel1343403enwheel
gunsel7339853guns_e_l
gunsels8338133guns_els
hell75637893___hell
indwell1143903indwell
inkwell1442533inkwell
install779363install
instill789063instill
knell94210923kn__ell
nutshells1242663nutshells
outsell7109263outs_ell
outsmell1075523outsmell
outspell10125453outspell
resell64215203res_ell
respell947023respell
seashell1144103seashell
sell45840613__s_ell
shall85024053__shall
sheal84927703__sheal
shelf115221113__shelf
shells94319523__shells
shelly124414473__shelly
sheol84318373__sheol
shill85325333__shill
skell94915833__skell
smell74916233__smell
snell54517303__snell
spell75020303__spell
subshells1444053subshells
swell84815983__swell
unbelt83015693un_belt
unfelt92413463un_felt
unhelms1234223un_helms
unhewn12285253un_hewn
unholy1238163un_holy
unideal837103unideal
unreal64414453un_real
unreel63612933un_reel
unreels7258313unreels
unroll61210073un_roll
unsafely1454413unsafely
unseals73212573unseals
unseam83313143uns_eam
unseat64221023uns_eat
unseemly1343763unseemly
unseen62012623uns_een
unsent63820963uns_ent
unset54532433uns_e_t
unsets64116163uns_ets
unsew83912693uns_e_w
unsewn9298393uns_ewn
unsews9379363uns_ews
unsex123512633uns_e_x
unsexy16296903uns_exy
unshapely1742823unshapely
unsharp1235543unsharp
unshelling1445593unshelling
unshift1387423unshift
unship1148033unsh_ip
unships1237203unships
unshod1067603unsh_od
unshorn1036943unshorn
unshowy1644173unshowy
unshut939013unsh_ut
unsnarl7107153unsnarl
unsold71410513uns_old
unspeak1344793unspeak
unspent92610893unspent
unsphere1355853unsphere
unspilt938853unspilt
unspool945163unspool
unsteels845793unsteels
unstep839223unste_p
unsteps936213unsteps
unsurely1146383unsurely
unswear1035003unswear
unswept1246013unswept
unveil957343un_veil
upheld12115563u_pheld
uphill11106173u_phill
upswells1342623upswells
upwell11285803u_pwell
usher84517763u_she_r
ushers94415533u_shers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271076.53020524.8
3Display Results1071070.0333242.4
 (SQL Overall)1786911076.96925640.8
 
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.