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

158 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
unhoods113750(None) 
unhood1039231unhood_
unhooks1436411unhooks
aunthoods1344332aunthoods
hoods95124082__hoods
manhoods1447242manhoods
snoods74312452sn_oods
sonhoods1247082sonhoods
unfolds11146802unfolds
unhands1137772unhands
unhooded13277872unhooded
unhook1347522unhoo_k
unipods1095702unipods
unloads8278522unloads
unmolds10135742unmolds
unmoors945902unmoors
unroofs1035782unroofs
unroots738562unroots
upholds13135242upholds
aholds10469483_aholds
aunthood1254723aunthood_
beholds1336423beholds
bhoots11459913_bhoots
bloods94614843_bloods
boyhoods1744883boyhoods
broods95416383_broods
cahoots1238473cahoots
chooks155312793_chooks
chords125214633_chords
dahoons1137753dahoons
endopods1245673endopods
enfolds11136253enfolds
enroots738713enroots
ephods1238363eph_ods
floods104511653_floods
foods95924163__foods
fungoids1343993fungoids
godhoods1444173godhoods
goods75124483__goods
gumwoods15123923gumwoods
gunrooms1144323gunrooms
hods87239863__h_ods
holds94623243__holds
hood85132333__hood_
hoody124919723__hoody
hoofs115721043__hoofs
hooks125027123__hooks
hoops105621073__hoops
hoots84830253__hoots
humanhoods1951953humanhoods
indoors838553indoors
infolds11137023infolds
inkwoods1674083inkwoods
inroads837043inroads
kinghoods1843483kinghoods
ladhoods1345873ladhoods
manhood1338993manhood_
monkhoods1984353monkhoods
moods85224623__moods
nods55838223_n__ods
nooks95420393_n_ooks
noons54125283_n_oons
nutwoods1244263nutwoods
onloads8246673onloads
poods85124753__poods
pushrods1443653pushrods
roods65125283__roods
schools1249113schools
schrods1337433schrods
shnooks1485583shnooks
shooks134515633_shooks
shools94919013_shools
shoos84226363_shoo_s
shoots94619363_shoots
snood64616163sn_ood_
snooks104412833sn_ooks
snools65715883sn_ools
snoops84314173sn_oops
snoots64216683sn_oots
sonhood1168313sonhood_
sunroofs1144763sunroofs
sunrooms1045723sunrooms
unbends10236993unbends
unbinds10267353unbinds
unbloody1482413unbloody
unbolts9247803unbolts
unbosoms1243263unbosoms
unboxes16208303unboxes
unchokes17227273unchokes
unclogs1036803unclogs
unclouds1144883unclouds
uncocks1537233uncocks
uncoils979533uncoils
uncool8610113uncoo_l
uncorks1337443uncorks
uncos74117033un_co_s
uncross938193uncross
undocks1436163undocks
undoers82910583undoers
undoes73917403un_does
unfold10179703unfold_
unfond10149113unfond_
ungirds9105303ungirds
unhairs1036373unhairs
unhand10410383unhand_
unhandy1445513unhandy
unhangs1136203unhangs
unhats91110623unh_ats
unhelms1234223unhelms
unholy1238163unh_oly
unhooding1435893unhooding
unhooked16286743unhooked
unhoped13249353unhoped
unhorse1038583unhorse
unhorses1138453unhorses
unhouse1038923unhouse
unhouses1138703unhouses
unhusks1443263unhusks
unibody1343353unibody
unions64216753un_ions
unipod946853unipod_
unisons748423unisons
unknots1144303unknots
unleads8228623unleads
unload73010803unload_
unlocks1337063unlocks
unloose797863unloose
unlooses8127293unlooses
unmold9148313unmold_
unmoor836313unmoo_r
unrobes9269733unrobes
unrolls797793unrolls
unroof9410193unroo_f
unroot6315553unroo_t
unrounds9145573unrounds
unshod1067603unshod_
unsold71410513unsold_
unspools1043693unspools
unstops936993unstops
untold7149683untold_
untrod769853untrod_
unwinds11286733unwinds
unwooded13207443unwooded
unwooed11229773unwooed
unyokes1466733unyokes
upfolds13133753upfolds
uphoards1443763uphoards
uphold12126903uphold_
uphroes1236303uphroes
uploads10266503uploads
uproots937143uproots
upshoots1344233upshoots
uropods1035873uropods
wahoos122310593wahoo_s
whoofs15457243_whoofs
whoops14487863_whoops
woods95723033__woods
yahoos12209243yahoo_s

Search took 7 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 Limit1340271586.43620824.6
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.90525878.5
 
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.