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

176 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
woollen103472(None) 
woolen93111371woo_len
woolled1136641woolled
woollens1144091woollens
woolmen1234971woolmen
pollen83416452_pollen
stollen747592stollen
swollen1034262swollen
wooden103610302woo_den
woodhen1454722woodhen
woodmen1356052woodmen
wooled103715502woo_led
woolens10398842woo_lens
wooler93615872woo_ler
woolie93514482woolie_
woolier103612352woolier
woolies104117362woolies
woollier1155432woollier
woollies1147412woollies
woolly12408512wooll_y
woolman1235432woolman
bolled94722653_bolled
boodle93215033boodle_
boodled113410933boodled
boodler103312003boodler
boodles103416043boodles
booklet132312643booklet
bookmen15126263bookmen
boomlet112412273boomlet
bootleg10276633bootleg
boulle84614613boulle_
boulles93114123boulles
colleen939543colleen
collet84030363_collet
cooled95224593coo_led
cooler84824713coo_ler
coolie83821603coolie_
coolies93824963coolies
coolly114811393cooll_y
dolled83518073_dolled
dolmen93911373_dolmen
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
doolees83711613doolees
doolie73916833doolie_
doolies83920713doolies
doormen1036753doormen
drolled93810223drolled
droller84110283droller
fallen93813373_fallen
folles93820473_folles
fooled104317823foo_led
footle93914383footle_
footled113610763footled
footler104011873footler
footles103715713footles
footmen1246583footmen
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
golden84411153_golden
goodmen1135623goodmen
holden104113953_holden
holler93520613_holler
holpen11299413_holpen
hooklet142510813hooklet
hoolie93217783hoolie_
knolled12296573knolled
knoller11285913knoller
lolled74315823_lolled
loller63315283_loller
loosen66615963loo_sen
molten83311813_molten
mooley11311633moo_ley
moonlet92413273moonlet
moorhen1236023moorhen
mullen83714763_mullen
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
oilmen848313_oilmen
olden65114853__olden
oodles73517183_oodles
polled94022003_polled
pollee83623273_pollee
pollens93713303_pollens
poller83921853_poller
pollex153711163_pollex
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
rolled74220243_rolled
roller63919793_roller
rootle63214453rootle_
rootled83410533rootled
rootles73215633rootles
rootlet73015733rootlet
stolen64315063sto_len
stollens835293stollens
sullen62914293_sullen
tolled73819033_tolled
toller63819443_toller
tollmen935733tollmen
tooled74918903too_led
tooler63818613too_ler
toolless836343toolless
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
trolled84312263trolled
troller73913173troller
trolley10328753trolley
volley12419743_volley
walled104021293w_alled
wallet93327093w_allet
welled103820213w_elled
whole114418093who_le_
wholes124616773who_les
wholly15366573wholl_y
whorled14366903whorled
willed104722453w_illed
willer94021063w_iller
willet95124833w_illet
wobble133212313wobble_
wobbled15349593wobbled
wobbler14329823wobbler
wobbles143412433wobbles
wofuller1442403wofuller
woken124614973w_o_ken
wolfed13428013w_olfed
wolfer12429983w_olfer
wolver12419713w_olver
wolves124510853w_olves
women104619253w_o_men
woodbin1354873woodbin
wooded114213683woo_ded
woodhens1534103woodhens
woodie103513613woodie_
woodier113912063woodier
woodies113517153woodies
woodland1344603woodland
woodless12278453woodless
woodlot1147023woodlot
woodman1336313woodman
woodsmen1444633woodsmen
wooed94419873woo__ed
wooer84316693woo__er
woofed134511203woo_fed
woofer124411363woo_fer
wool76427373woo_l__
woolers104214023woolers
woolfell1442243woolfell
woolhat1346043woolhat
wooliest113011643wooliest
woolliest1235853woolliest
woollike1534983woollike
woollily1443123woollily
wools84421463woo_l_s
woolshed1553923woolshed
woolskin1543013woolskin
wooly114417673woo_l_y
woopsed1344743woopsed
woopses1237883woopses
wooshed14167403wooshed
wooshes13169883wooshes
woozier19347323woozier
workmen1635933workmen
worsen95513873w_orsen
woven115215173w_o_ven
zooglea1733373zooglea

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271766.83019623.3
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.29624491.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.