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

114 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
dewooled133383(None) 
befooled1434802befooled
dewool1047402dewool__
dewools1145592dewool_s
dewormed15236222dewormed
drooled9369202d_rooled
retooled938472retooled
wooled103715502__wooled
befouled1434683befouled
behooved1743133behooved
behowled1733473behowled
bewailed1435343bewailed
bewormed16235443bewormed
cooled95224593__cooled
dawdled13376723daw_dled
deaconed1237493deaconed
deboned113411633de_boned
decocted1437683decocted
decoded123212383de_coded
decolored1345663decolored
decoupled15114283decoupled
decoyed14358333de_coyed
decupled1494983decupled
defiled124013103de_filed
defoamed15356243defoamed
defogged1533783defogged
deforced15247373deforced
deformed15248263deformed
defueled1374513defueled
dehorned1345683dehorned
dehorted1357303dehorted
deled75326543de___led
deloused1036973deloused
demobbed1643203demobbed
demoded123611123de_moded
demoed103713443de_mo_ed
demoted114313543de_moted
denoted93512763de_noted
dentiled1039743dentiled
depeopled1543223depeopled
deplored1237223deplored
deployed1535903deployed
deponed113712873de_poned
deported1249703deported
deposed113412023de_posed
derailed102410403derailed
desorbed1236443desorbed
despoiled1344653despoiled
detailed10319873detailed
detoured1036513detoured
detoxed1636103de_toxed
develed123611933de_veled
deviled124112183de_viled
devilled1336743devilled
devoiced15276063devoiced
devolved16325513devolved
devoted124111093de_voted
devoured1335723devoured
dewaxed19316053dew_axed
dewed105020303dew___ed
dewooling1444323dewooling
dewormer14256323dewormer
doiled84817293d__oiled
doled75430913d___oled
dolled83518073d__olled
doodled10369463d_oodled
doolee73018953d__oolee
doomed104113293d__oomed
doweled12269773dow_eled
dowelled1356343dowelled
drolled93810223d_rolled
drooped11368433d_rooped
dwelled12337593d_welled
dyewood1554143dyewoo__d
fooled104317823__fooled
jeweled1845333jew_eled
jewelled1934333jewelled
mewled123710053mew__led
peopled1238493pe_opled
petioled1137993petioled
pooled94619813__pooled
precooled1446363precooled
reboiled11349393reboiled
rebooked15226503rebooked
rebooted11248463rebooted
recoaled113111783recoaled
recoiled113613213recoiled
recooked15268243recooked
relooked13236653relooked
reoiled84316853re_oiled
repolled11359623repolled
rerolled93010043rerolled
reroofed1235873reroofed
resoled84119283re_soled
respooled1245593respooled
reworded13228103reworded
reworked16247773reworked
schooled1447053schooled
shooled115212663_shooled
snooled84513943_snooled
spooled104613523_spooled
stooled84313893_stooled
swooned11368593_swooned
swooped13418753_swooped
tooled74918903__tooled
uncooled112710633uncooled
unwooded13207443unwooded
unwooed11229773unwoo_ed
wooded114213683__wooded
wooed94419873__woo_ed
woofed134511203__woofed
woolen93111373__woolen
wooler93615873__wooler
woolled1136643__woolled

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.1561145455.1
2DLD Change Limit1461621147.29620033.2
3Display Results1141140.0333454.5
 (SQL Overall)1786911147.48523873.2
 
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.