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

288 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
unhatted123818(None) 
unmatted1138291unmatted
chatted133411892_chatted
hatted104921512__hatted
unacted10312732un_acted
unbasted112510072unbasted
unbated103317732unba_ted
unbathed1437222unbathed
unbitted1138212unbitted
uncarted11312052uncarted
uncharted1538082uncharted
undated93118462unda_ted
undotted1048522undotted
unfitted1238162unfitted
ungated92717212unga_ted
unhailed12219962unhailed
unhaired12238762unhaired
unhalved1556512unhalved
unhanded132910182unhanded
unhanged13258832unhanged
unharmed1438092unharmed
unhatched1844132unhatched
unheated121514552unheated
unletted9310312unletted
unmated103317022unma_ted
unparted11310822unparted
unpitted1148622unpitted
unpotted11108392unpotted
unrated82621552unra_ted
unsalted9510922unsalted
unsated83419932unsa_ted
unstated91615812unstated
untasted92011572untasted
unwanted12249602unwanted
unwasted12259782unwasted
unwetted1238122unwetted
unwitted1237542unwitted
ansated84214003ansa_ted
batted95623653__batted
blatted104812713_blatted
catted95422473__catted
chanted134015953_chanted
charted135116853_charted
chattel12388893_chattel
chatter124416643_chatter
cuneated11310103cunea_ted
defatted1335673defatted
deratted1048403deratted
dratted9358593_dratted
enacted10310643en_acted
enchanted1546553enchanted
enhaloed12125933enhaloed
enhanced1436623enhanced
fatted105419843__fatted
flatted114012943_flatted
hafted134713833__hafted
halted105019603__halted
hanted104124313__hanted
hasted105125283__hasted
hated95734023__ha_ted
hatred104814333__hatred
hatter94724873__hatter
hotted104319943__hotted
hutted104616333__hutted
incanted11259543incanted
inhabited1544673inhabited
inhaled1169333inha_led
inputted1134663inputted
insetted9249023insetted
instated91613343instated
knitted12337423kn_itted
knotted12357233kn_otted
lunated8310823lun_a_ted
matted94521413__matted
natter64420743_n_atter
netted74118713_n_etted
notated82713663_notated
nutated83113423nuta_ted
nutted74316973_n_utted
patted94724683__patted
phatter123810203_phatter
platted103614263_platted
punctated1445053punctated
ratted74923343__ratted
scatted103512773_scatted
shafted14288813_shafted
shatter103615703_shatter
shitted114212053_shitted
shotted113912403_shotted
slatted84015183_slatted
spatted104014143_spatted
splatted11356743splatted
squatted1835343squatted
sunbathed1543313sunbathed
swatted114110693_swatted
tatted74920533__tatted
umlauted1132823umlauted
unabated11310133unabated
unabetted1244993unabetted
unadapted1344653unadapted
unadded10238523un_added
unaged83916423un_a_ged
unaided92414603un_aided
unaimed102812493un_aimed
unaired82916013un_aired
unarmed101811923un_armed
unasked122010023un_asked
unatoned939423un_atoned
unattired1045083un_attired
unattuned1043343un_attuned
unawed103914903un_a_wed
unaxed144113093un_a_xed
unbacked17268733unbacked
unbaked143312893unba_ked
unbaled103315963unba_led
unbanded123010563unbanded
unbanned11279113unbanned
unbarbed13217753unbarbed
unbarred11238703unbarred
unbased103513483unba_sed
unbelted1179333unbelted
unbitten1045213unbitten
unbitter1046173unbitter
unbolted1179323unbolted
unbooted1188773unbooted
unbottled1244153unbottled
unbusted11258773unbusted
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncanned11289963uncanned
uncapped1556693uncapped
uncarded12310133uncarded
uncarved1438163uncarved
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncatered1237403uncatered
uncaused1138453uncaused
unchained1537273unchained
unchaired1536203unchaired
unchanged1636283unchanged
uncharged1636613uncharged
uncharred1536103uncharred
unchaste1346923unchaste_
unchaster1445393unchaster
uncoated11314963uncoated
uncrated11416313uncrated
undamped1445333undamped
undaunted1145453undaunted
undented102313953undented
unearned9310063unearned
unearthed1345573unearthed
uneaten7412543unea_ten
unedited10249833unedited
unexalted1744333unexalted
unfaded123111733unfa_ded
unfaked153211173unfa_ked
unfasten1144843unfasten
unfazed20299053unfa_zed
unfelted1279403unfelted
unfetter1136753unfetter
unfluted1237173unfluted
ungalled1078463ungalled
ungarbed12197063ungarbed
ungifted13116833ungifted
ungotten944533ungotten
unhairer11174993unhairer
unhand10410383unha__nd
unhandled1445703unhandled
unharried1344763unharried
unhasty1344283unhast_y
unhat81119263unha_t__
unhats91110623unha_t_s
unhatting1335873unhatting
unhealed121511073unhealed
unhedged1434973unhedged
unheeded1336893unheeded
unhelmed1435993unhelmed
unhelped1435923unhelped
unhinged13257473unhinged
unhired112512153unh_ired
unhitched1843093unhitched
unhooded13277873unhooded
unhooked16286743unhooked
unhoped13249353unh_oped
unhorsed1238833unhorsed
unhoused1238153unhoused
unhusked1634603unhusked
united74421543un__ited
unjaded16279143unja_ded
unjammed2033623unjammed
unknitted1443703unknitted
unknotted1443623unknotted
unlaced102913733unla_ced
unladed92614373unla_ded
unlashed12289183unlashed
unlatched1544213unlatched
unlisted9311153unlisted
unmailed11229763unmailed
unmanned11268603unmanned
unmapped1535173unmapped
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmatched1744203unmatched
unmatured1245693unmatured
unmelted1169183unmelted
unmitred1136843unmitred
unnailed9229443unnailed
unnamed102410273unna_med
unnoted8311363un_noted
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unpa_ged
unpainted1237183unpainted
unpaired11208943unpaired
unpatched1744053unpatched
unpaved133410053unpa_ved
unpitied1138793unpitied
unplaited1236883unplaited
unplanted1236853unplanted
unposted1159433unposted
unquoted1836533unquoted
unraised91811883unraised
unraked122914013unra_ked
unranked1338563unranked
unrazed172511453unra_zed
unrented92413923unrented
unrested91914513unrested
unroasted1036613unroasted
unrooted9810513unrooted
unrusted92310353unrusted
unsaved113312193unsa_ved
unsawed112911503unsa_wed
unscathed1535313unscathed
unseated91317683unseated
unsettled1055213unsettled
unshaded13149263unsha_ded
unshamed14148053unsha_med
unshaped14148443unsha_ped
unshared121510703unsha_red
unshaved15157733unsha_ved
unsheathed17174133unsheathed
unshifted16124943unshifted
unshirted13105953unshirted
unsifted12128773unsifted
unsorted9312513unsorted
unspotted1244933unspotted
unstate71916213unstate_
unstates81314993unstates
unstayed12168393unstayed
unsuited9310793unsuited
unswathed1634543unswathed
untacked15239923untacked
untagged1135973untagged
untainted1038423untainted
untamed102913223unta_med
untanned9279963untanned
untapped1376613untapped
untaxed152710583unta_xed
untented92613413untented
untested92612413untested
unthanked1764663unthanked
unthawed1535583untha_wed
untied73720813un__tied
untilted9610893untilted
untitled978763untitled
untufted1236083untufted
ununited938683ununited
unvalued1266313unvalued
unvaried1239683unvaried
unvested122210223unvested
unwalled1288653unwalled
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
unwashed15288483unwashed
unwatched1844083unwatched
unwatered1345683unwatered
unwaxed18308393unwa_xed
unwonted12248643unwonted
updarted1244313updarted
updated11369423upda_ted
uprated103213323upra_ted
upwafted1742193upwafted
vatted104214733__vatted
whetted14256693_whetted

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.423422437.4
2DLD Change Limit1461622886.61022112.3
3Display Results2882880.1232341.5
 (SQL Overall)1786912887.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.