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

127 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
woollens114409(None) 
woolens10398841woo_lens
woollen1034721woollen_
pollens93713302_pollens
stollens835292stollens
toolless836342toolless
woodhens1534102woodhens
woodless12278452woodless
woolen93111372woo_len_
woolers104214022woo_lers
woolies104117362woolie_s
woolled1136642woolle_d
woollies1147412woollies
woolmen1234972woolmen_
boodlers113710743boodlers
boodles103416043boodle_s
booklets14247123booklets
boomlets12246673boomlets
boonless10328353boonless
bootlegs11325873bootlegs
bootless103410983bootless
boulles93114123boulle_s
coalless1038193coalless
colleens1036843colleens
collets93517903_collets
collins93419833_collins
cookless14258633cookless
coolers93522493coo_lers
coolies93824963coolie_s
coolness1037743coolness
dolmens10388693_dolmens
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613doo_lees
doolies83920713doolie_s
doorless936713doorless
folles93820473_folle_s
foodless12338383foodless
footlers113910793footlers
footles103715713footle_s
footless113710803footless
foozlers20346073foozlers
foozles19329543foozle_s
goalless935723goalless
hollers103818233_hollers
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hooklets15217203hooklets
hoopless13279263hoopless
knollers12255143knollers
lollers72713793_lollers
loosens716310953loo_sens
mooleys1236863moo_leys
moonless10278043moonless
moonlets10247473moonlets
moorhens1344853moorhens
mullens93611313_mullens
noodles83513193noodle_s
oodles73517183_oodle_s
oodlins83210513_oodlins
pollees93215333_pollees
pollen83416453_pollen_
pollers93420023_pollers
poodles103013513poodle_s
poolers94217423poo_lers
rollers73117473_rollers
roofless11316733roofless
rootles73215633rootle_s
rootless83910443rootless
rootlets8308653rootlets
soilless8279033soilless
soulless8218763soulless
stollen747583stollen_
swollen1034263swollen_
tollers73217463_tollers
toolers74416503too_lers
tootlers8289503tootlers
tootles72915603tootle_s
trollers83211213trollers
trolleys11315693trolleys
volleys13316643_volleys
wallets103914833w_allets
wholes124616773who_le_s
willers103517913w_illers
willets104414323w_illets
wobblers15327883wobblers
wobbles143412433wobble_s
wolfers13409633w_olfers
wolvers13349313w_olvers
wolves124510853w_olve_s
woodbins1445043woodbins
wooden103610303woo_den_
woodhen1454723woodhen_
woodies113517153woodie_s
woodland1344603woodland
woodlands1444153woodlands
woodlots1245343woodlots
woodmen1356053woodmen_
wooers93712443woo__ers
woofers133810583woo_fers
wooled103715503woo_le_d
wooler93615873woo_le_r
woolfell1442243woolfell
woolfells1541963woolfells
woolhats1443593woolhats
woolie93514483woolie__
woolier103612353woolie_r
wooliest113011643wooliest
wooliness12147693wooliness
woollier1155433woollier
woolliest1235853woolliest
woollike1534983woollike
woollily1443123woollily
woolliness1343563woolliness
woolly12408513wooll__y
woolman1235433woolman_
wools84421463woo_l__s
woolsheds1642553woolsheds
woolskins1643003woolskins
woopses1237883woopse_s
wooshes13169883wooshe_s
wordless12258843wordless
workless15276803workless
worsens104610263w_orsens
wovens12449833w_o_vens
zoogleas1843373zoogleas

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 Limit1461621276.70321805.5
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.18524870.0
 
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.