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

177 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
unhelped143592(None) 
unhelmed1435991unhelmed
helped124714152__helped
unbelted1179332unbelted
unfelted1279402unfelted
ungelded1147402ungelded
unhalved1556512unhalved
unhealed121511072unhealed
unheated121514552unheated
unhedged1434962unhedged
unheeded1336892unheeded
unhoped13249352unh_oped
unmelted1169182unmelted
unshelled1336562unshelled
unwelded1337132unwelded
upheaped1633642upheaped
whelped16355632_whelped
aneled74719273an_el_ed
angeled93211503angel_ed
busheled1465263bushel_ed
bushelled1543973bushelled
cheeped153410593_cheeped
cheliped1635043_cheliped
enhaloed12125933enhaloed
enveloped1543553enveloped
funneled1254873funnel_ed
funnelled1374233funnelled
heaped124516903__heaped
helled104024703__helled
helmed124513693__helmed
helper114313093__helper
helved134313703__helved
inhaled1169333inhal_ed
inhered11313163inhe_red
kelped13449543__kelped
kneeled12328063kneel_ed
knelled12338983kn_elled
outyelped1543333outyelped
shelled113815083_shelled
shelved14379933_shelved
skelped1435203_skelped
sneaped10338813sn_eaped
snelled83313043sn_elled
tunneled955233tunnel_ed
tunnelled1054583tunnelled
umbeled12208193umbel_ed
umbelled1336273umbelled
unallied938393unallied
unaneled939793unanel_ed
unbaled103315963unbal_ed
unbeared111611653unbeared
unbelief1346773unbelief
unbeloved1543923unbeloved
unbended12279973unbended
unbilled1188693unbilled
unbolted1179323unbolted
uncalled11810923uncalled
uncapped1556693uncapped
unceded11410563unce_ded
unchecked2144063unchecked
unchewed1735803unche_wed
unchilled1545563unchilled
undamped1445333undamped
undecked16238493undecked
undeleted1148063undeleted
undeluded1244363undeluded
undenied102211563undenied
undented102313953undented
underfed13311713underfed
undraped1239393undraped
undulled1036993undulled
unended92811823un_ended
unfeared121511013unfeared
unfenced1437733unfenced
unfilled1298383unfilled
unfilmed1495803unfilmed
unflexed1935253unflexed
unfolded1338313unfolded
ungalled1078463ungalled
unglued937303un_glued
unhailed12219963unhailed
unhaired12238763unhaired
unhanded132910183unhanded
unhanged13258833unhanged
unharmed1438093unharmed
unhatted1238183unhatted
unheard1136943unhe_ard
unhelm1136863unhel__m
unhelms1234223unhel_ms
unhelpful1751633unhelpful
unheralded1543533unheralded
unhinged13257473unhinged
unhired112512153unh_ired
unholier1137283unholier
unhooded13277873unhooded
unhooked16286743unhooked
unhorsed1238833unhorsed
unhoused1238153unhoused
unhusked1634603unhusked
unkeeled13117183unkeeled
unkenned1336183unkenned
unleaded10411333unleaded
unleased9310713unleased
unled64021073un__l_ed
unletted9310313unletted
unlevied1236843unlevied
unmapped1535173unmapped
unmended12299093unmended
unmeshed1437003unmeshed
unmewed13258173unme_wed
unmilled1197853unmilled
unmolded1237453unmolded
unneeded1036483unneeded
unnerved1248063unnerved
unoiled82415473unoil_ed
unpeeled11118533unpeeled
unpegged1334353unpegged
unpenned1137543unpenned
unpeopled1444533unpeopled
unpiled102312743unpil_ed
unpolled1168943unpolled
unquelled1944413unquelled
unreeled91310333unreeled
unreeved12117673unreeved
unrelated10310433unrelated
unrelaxed1744453unrelaxed
unrented92413923unrented
unrested91914513unrested
unripped1335763unripped
unrolled9610413unrolled
unroped102812103un_roped
unruled8311373unrul_ed
unsalted9510923unsalted
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseeded1038253unseeded
unseized1838443unseized
unserved12410233unserved
unsewed112911023unse_wed
unsexed152410253unse_xed
unshaped14148443unshaped
unshipped1743863unshipped
unsolved1237833unsolved
unstepped1444213unstepped
untapped1376613untapped
untended102611153untended
untented92613413untented
untested92612413untested
untilled9710563untilled
untilted9610893untilted
untipped1335763untipped
unvalued1266313unvalued
unveiled1298163unveiled
unveined1258003unveined
unversed122310433unversed
unvested122210223unvested
unvexed18147103unve_xed
unwalled1288653unwalled
unwarped1436873unwarped
unweaned1238593unweaned
unwedded1435393unwedded
unweeded1336563unweeded
unwetted1238123unwetted
unwhipped2042363unwhipped
unwilled1277823unwilled
unyeaned1237743unyeaned
unzipped2233213unzipped
upheaved1733763upheaved
upheld12115563uphel__d
upleaped1334333upleaped
upwelled1434663upwelled
ushered1139153ushe_red
wheeped16387503_wheeped
whelmed16375153_whelmed
yelped12439363__yelped

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621776.92321112.5
3Display Results1771770.0802212.5
 (SQL Overall)1786911777.15624970.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.