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

169 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
unhelm113686(None) 
unhelms1234221unhelms
helm95530022__helm
unbelt83015692unbelt
unfelt92413462unfelt
unhelmed1435992unhelmed
unhewn12285252unhewn
unholy1238162unholy
unseam83313142unseam
unsell63512542unsell
unshell1047112unshell
unwell9349442unwell
upheld12115562upheld
whelm134611982_whelm
ahem97225363_ahe_m
anele55628833an_ele
angel65019563angel_
angels74416173angels
anthem113410343anthe_m
beheld1236413beheld
bushel114513943bushel_
bushels124110713bushels
chela103916803_chela
dishelm1335833dishelm
elm57531743___elm
enhalo987563enhalo
funnel93610743funnel_
funnels10348173funnels
gunnel73411053gunnel_
gunnels8358563gunnels
gunsel7339853gunsel_
gunsels8338133gunsels
halm95834973__halm
held85330403__held
hell75637893__hell
helms105619463__helms
helo75332853__helo
help95328923__help
hem86148733__he_m
herm95636153__herm
holm95628113__holm
inhale9411513inhale
inhere9313713inhere
inseam8329993inseam
kneel95012033kneel_
kneels10408933kneels
knell94210923kn_ell
knelt94617683kn_elt
mohel104914833mohel_
mohelim1444763mohelim
mohels115011323mohels
neem67328083_n_eem
neum66723083_n_eum
noel45226553_noel_
noels56418703_noels
nudely10299033nudely
rehem103815353rehe_m
rheum1038843_rheum
runnel63510663runnel_
runnels7329153runnels
shelf115221113_shelf
shell84424123_shell
skelm114211293_skelm
snell54517303sn_ell
sunbeam1146053sunbeam
sunbelt939233sunbelt
them97427043_the_m
therm106018023_therm
tunnel64310633tunnel_
tunnels7328723tunnels
umbel93612843umbel_
umbels104510593umbels
unable83819223unable
unarm7314453un_arm
unbale83616403unbale
unbe65319273unbe__
unbear889163unbear
unbelts9237663unbelts
unbend9269773unbend
unbent83216593unbent
unbolt83013893unbolt
uncle7317053un_cle
uncles8317163uncles
unde55825483unde__
undead82711903undead
undee65327273unde_e
under64624213unde_r
unduly1037823unduly
unfed94614223unfe_d
unfold10179703unfold
ungula737603ungula
unhair937333unhair
unhand10410383unhand
unhang1038443unhang
unhat81119263unh_at
unhats91110623unhats
unhealed121511073unhealed
unheard1136943unheard
unhelming1535493unhelming
unhelped1435923unhelped
unhip10178823unh_ip
unhood1039233unhood
unhook1347523unhook
unhung1035283unhung
unhurt9311253unhurt
unhusk1334263unhusk
unjam1448723un_jam
unkend11309223unkend
unkent103116053unkent
unkept123710873unkept
unlead73312373unlead
unled64021073unle_d
unless62413073unless
unlet54133333unle_t
unmeet83815743unmeet
unmesh1145793unmesh
unmet74426393unme_t
unmew103610073unme_w
unmews11326523unmews
unmold9148313unmold
unpeg8309363unpe_g
unpegs9256233unpegs
unpen72913573unpe_n
unpens82511013unpens
unpent83117373unpent
unpile81914323unpile
unread73412673unread
unreal64414453unreal
unreel63612933unreel
unreels7258313unreels
unrent63219783unrent
unrest62918853unrest
unroll61210073unroll
unruly938083unruly
unseal63315473unseal
unseals73212573unseals
unseams9338913unseams
unseat64221023unseat
unseen62012623unseen
unsells73210773unsells
unsent63820963unsent
unset54532433unse_t
unsets64116163unsets
unsew83912693unse_w
unsewn9298393unsewn
unsews9379363unsews
unsex123512633unse_x
unsexy16296903unsexy
unshed10313773unshe_d
unshells1145923unshells
unsold71410513unsold
until53517743until_
untold7149683untold
untrim8310683untrim
unveil957343unveil
unveils1045753unveils
unvext1658173unvext
unwed94114873unwe_d
unwept11389813unwept
unwet84423173unwe_t
upheap13105213upheap
uphill11106173uphill
uphold12126903uphold
upwell11285803upwell
usher84517763ushe_r
ushers94415533ushers
whelk154311063_whelk
whelms14377573_whelms
whelp136012093_whelp

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161695.25021469.7
3Display Results1691690.0463673.9
 (SQL Overall)1786911695.66931520.7
 
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.