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 “wooly” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
wooly11441767(None) 
cooly105525421cooly
dooly94821801dooly
hooly115022221hooly
woody125116881woody
wool76427371wool_
woolly12408511woolly
wools84421461wools
woozy204410601woozy
booby125319512booby
boody115420402boody
boogy114518322boogy
boomy125421822boomy
booty106125912booty
boozy194917062boozy
coaly105521592coaly
colly104926772colly
coly96940532_coly
cooey105828222cooey
cooky145321362cooky
cool66940492cool_
coolly114811392coolly
cools75632632cools
coyly135614892coyly
dhooly13457142dhooly
doily95321032doily
dolly96125202dolly
doody105517912doody
doomy116018262doomy
doozy186813712doozy
doyly124514012doyly
drooly104911072drooly
folly115022602folly
fool75330592fool_
fools86824202fools
footy115820532footy
godly104913292godly
golly95121102golly
goodly11419302goodly
goody105620392goody
gooey95522862gooey
goofy124915622goofy
googly11417882googly
gooky135818032gooky
goony95519782goony
goopy115816622goopy
goosy96018882goosy
holly114824432holly
holy106333432_holy
hoody124919722hoody
hooey114926602hooey
hooky155220262hooky
hooty115022442hooty
hotly115815482hotly
jolly154517512jolly
jowly186410902jowly
kooky114412872kooky
lolly85120662lolly
looby108115622looby
looey84822912looey
loony86918962loony
loopy105316642loopy
lowly114113332lowly
molly105222492molly
moly96031912_moly
moody115017492moody
mool67533862mool_
moola75117032moola
mooley11311632mooley
mools76027172mools
moony104818272moony
moory105115792moory
nobly105314402nobly
noily86120992noily
nooky124814812nooky
oily77932252_oily
only75319722_only
oozy167018132_oozy
poly96235152_poly
poofy136213272poofy
pool65835952pool_
pools74427702pools
poorly1137892poorly
roily86121112roily
rooky126117622rooky
roomy107118062roomy
rooty86423022rooty
sonly85718052sonly
sooey84522432sooey
sooty84924842sooty
swoony12408262swoony
swoopy14487282swoopy
tool46735682tool_
tools55325242tools
wally114625092wally
waly105830902w_aly
wanly115118022wanly
welly114620012welly
wetly114511712wetly
whole114418092whole
wholly15366572wholly
willy115321912willy
wily106428812w_ily
woald94813072woald
wobbly16347092wobbly
wold85429072w_old
wolf105729562w_olf
womby155910092womby
wonky154011772wonky
woo66949802woo__
wood85329382woo_d
woods95723032woods
woodsy13505922woodsy
wooed94419872wooed
wooer84316692wooer
woof106532422woo_f
woofs114918002woofs
wooled103715502wooled
woolen93111372woolen
wooler93615872wooler
woolie93514482woolie
woops104917522woops
woos76238802woo_s
woosh113710732woosh
woozily2234382woozily
wordy126916162wordy
world96915362world
wormy137514252wormy
worry116114332worry
would95513152would
wryly14356702wryly
zooey173914802zooey
zooty175415352zooty

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001331.65632487.9
3Display Results1331330.0334030.3
 (SQL Overall)1786911331.782100275.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.