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

225 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
untapped137661(None) 
uncapped1556691uncapped
unmapped1535171unmapped
untipped1335761untipped
untrapped14106121untrapped
entrapped1484872entrapped
knapped16397102kn_apped
napped114218162_n_apped
snapped124611202sn_apped
tapped113820052__tapped
undamped1445332undamped
unflapped1743092unflapped
unripped1335762unripped
unsnapped1443982unsnapped
unstamped1454602unstamped
unstepped1444212unstepped
unstopped1444402unstopped
unstrapped1573562unstrapped
untacked15239922untacked
untagged1135972untagged
untamed102913222unta_med
untanned9279962untanned
untasted92011572untasted
untaxed152710582unta_xed
unwarped1436872unwarped
unwrapped1784132unwrapped
unzipped2233212unzipped
becapped1733933becapped
bitmapped1841433bitmapped
capped134721853__capped
catnapped1692503catnapped
chapped172711443_chapped
clapped143511173_clapped
crapped143912623_crapped
dapped124516763__dapped
encamped1535023encamped
entailed989523entailed
entrapper1344853entrapper
enwrapped1742793enwrapped
estopped1334993estopped
flapped15328253_flapped
frapped15318853_frapped
gapped124217123__gapped
happed144820103__happed
inwrapped1742643inwrapped
knapper15387153kn_apper
knopped16355453kn_opped
lapped114320033__lapped
mapped134015883__mapped
mudcapped1941383mudcapped
nappe96114993_n_appe_
napper103718283_n_apper
nappes104515623_n_appes
nipped113615853_n_ipped
nutated83113423nuta_ted
petnapped1342383petnapped
rapped114122683__rapped
recapped1535943recapped
remapped1534913remapped
retaped103814283reta_ped
sapped114422013__sapped
scrapped1556533scrapped
slapped123511843_slapped
snapper113512073sn_apper
sneaped10338813snea_ped
snipped123510043sn_ipped
stamped124812813_stamped
stapled103613703_stapled
stepped123210053_stepped
stopped124512203_stopped
strapped1357823strapped
suntanned1044013suntanned
swapped15429143_swapped
tamped114317043__tamped
taped85327423__ta_ped
tapper104419613__tapper
tappet103820113__tappet
tipped114418263__tipped
topped114617723__topped
trapped124512213_trapped
tupped114013233__tupped
unacted10312733un_acted
unadapted1344653unadapted
unadded10238523un_added
unaged83916423un_a_ged
unaided92414603un_aided
unaimed102812493un_aimed
unaired82916013un_aired
unapplied1443743un_applied
unarmed101811923un_armed
unasked122010023un_asked
unatoned939423unatoned
unawed103914903un_a_wed
unaxed144113093un_a_xed
unbacked17268733unbacked
unbaked143312893unba_ked
unbaled103315963unba_led
unbanded123010563unbanded
unbanned11279113unbanned
unbarbed13217753unbarbed
unbarred11238703unbarred
unbased103513483unba_sed
unbasted112510073unbasted
unbated103317733unba_ted
unbathed1437223unbathed
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncanned11289963uncanned
uncarded12310133uncarded
uncarted11312053uncarted
uncarved1438163uncarved
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncaused1138453uncaused
unclamped1664503unclamped
unclasped1465503unclasped
unclipped1643843unclipped
uncropped1644933uncropped
undated93118463unda_ted
undraped1239393undraped
unearned9310063unearned
unfaded123111733unfa_ded
unfaked153211173unfa_ked
unfazed20299053unfa_zed
ungalled1078463ungalled
ungarbed12197063ungarbed
ungated92717213unga_ted
unhailed12219963unhailed
unhaired12238763unhaired
unhalved1556513unhalved
unhanded132910183unhanded
unhanged13258833unhanged
unhappier1642393unhappier
unhappy1742803unhapp_y
unharmed1438093unharmed
unhatted1238183unhatted
unhelped1435923unhelped
unhoped13249353un_hoped
unjaded16279143unja_ded
unjammed2033623unjammed
unlaced102913733unla_ced
unladed92614373unla_ded
unlashed12289183unlashed
unmailed11229763unmailed
unmanned11268603unmanned
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmated103317023unma_ted
unmatted1138293unmatted
unnailed9229443unnailed
unnamed102410273unna_med
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unpa_ged
unpaired11208943unpaired
unparted11310823unparted
unpaved133410053unpa_ved
unraised91811883unraised
unraked122914013unra_ked
unranked1338563unranked
unrated82621553unra_ted
unrazed172511453unra_zed
unroped102812103un_roped
unsalted9510923unsalted
unsampled1444443unsampled
unsated83419933unsa_ted
unsaved113312193unsa_ved
unsawed112911503unsa_wed
unshaped14148443unshaped
unshipped1743863unshipped
unstacked1636433unstacked
unstained1038683unstained
unstalked1435523unstalked
unstarred1036363unstarred
unstated91615813unsta_ted
unstayed12168393unsta_yed
unstopper1343523unstopper
unstriped1246303unstriped
untainted1038423untainted
untaken1137643unta_ken
untame82513603unta_me_
untangled1165123untangled
untended102611153untended
untented92613413untented
untested92612413untested
unthanked1764663unthanked
unthawed1535583unthawed
untidied1038903untidied
untied73720813unt__ied
untilled9710563untilled
untilted9610893untilted
untimed102713373unt_imed
untinged10308943untinged
untired82316383unt_ired
untitled978763untitled
untraced112413243untraced
untracked16228373untracked
untrained10510993untrained
untried82615853unt_ried
untucked15206053untucked
untufted1236083untufted
untuned82010823unt_uned
unturned9228563unturned
untwined1237063untwined
unvalued1266313unvalued
unvaried1239683unvaried
unwalled1288653unwalled
unwanted12249603unwanted
unwarmed1437303unwarmed
unwarned1238453unwarned
unwashed15288483unwashed
unwasted12259783unwasted
unwaxed18308393unwa_xed
unwhipped2042363unwhipped
upped103715163u___pped
upstepped1341943upstepped
uptalked1533053uptalked
wapped144416473__wapped
whapped18367573_whapped
wrapped15338023_wrapped
yapped144415143__yapped
zapped204213523__zapped

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.436409841.7
2DLD Change Limit1461622256.61022112.3
3Display Results2252250.0802812.5
 (SQL Overall)1786912257.12625075.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.