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

185 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
dewool104740(None) 
dewools1145591dewools
befool1137712befool
dewooled1333832dewooled
deworm1249532deworm
drool65416102d_rool
dyewood1554142dyewood
retool63914482retool
wool76427372__wool
aerosol747683aerosol
aswoon947013aswoon
awol75620673_aw_ol
babool103012153babool
befools1236433befools
befoul1137253befoul
behoof1458683behoof
behowl1445533behowl
benzol1756993benzol
betook12439603betook
bewail1189583bewail
beworm1339993beworm
ceorl7410923ce_orl
cool66940493__cool
dagwood1344833dagwood
dahoon1039053dahoon
deacon9510423deacon
deadwood1444843deadwood
deal56347413de__al
deasil71110983deasil
debone93714783debone
debtor938333debtor
decal85523233de_cal
deckel134911043deckel
deco76125973de_co_
decoct11313783decoct
decode104414743decode
decolor1087033decolor
decor84717573de_cor
decors94017773decors
decos85522123de_cos
decoy115716313de_coy
decoys123911283decoys
dedal75719023de_dal
defoam1238563defoam
defog1048523de_fog
defogs1156683defogs
deform1259623deform
defuel10348933defuel
dehorn10439653dehorn
dehort104618103dehort
deil56231623de__il
dekko936393dekko_
dekkos1034103dekkos
del46752753de___l
dell56938203de__ll
demo77427553de_mo_
demob104913503de_mob
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demon86520313de_mon
demons94917723demons
demos86022993de_mos
demote94817803demote
denial74720513denial
denote74118043denote
dental74319173dental
dentil74017883dentil
deoxy1648883de_oxy
deploy1237583deploy
depone93616553depone
deport94922393deport
deposal1037153deposal
depose94215763depose
depot85727923de_pot
depots94716343depots
derail74218813derail
dermal93614343dermal
desorb95210203desorb
desoxy1744623desoxy
despoil1046523despoil
despot93413293despot
detail74516433detail
detour778193detour
detox13310953de_tox
devel94217123de_vel
devil94714733de_vil
devoid1189363devoid
devoir1076033devoir
devon95113683de_von
devons104512253devons
devote104513783devote
devour1076703devour
devout10712993devout
dew77139923dew___
dewan95718043dew_an
dewans105215143dewans
dewar95817733dew_ar
dewars105117073dewars
dewax165510853dew_ax
dewdrop1442813dewdrop
dewed105020303dew_ed
dewfall1453763dewfall
dewier104013463dewier
dewily1338343dewily
dewing114115703dewing
dewlap1264843dewlap
dewooling1444323dewooling
deworms1338033deworms
dews86230603dew__s
dewy115419023dew__y
dhooly13457143d_hooly
diobol936883diobol
diol57329133d__iol
dogwood1354913dogwood
dol47150653d___ol
doll56632493d__oll
dooly94821803d__ooly
doom76430073d__oom
door56928513d__oor
doowop1283853doowop
dowel95618193dow_el
droll65415403d_roll
drools74412813d_rools
drooly104911073d_rooly
droop85814823d_roop
dwell9519853d_well
dyewoods1643503dyewoods
ebook114510803_ebook
enol45823823_e_nol
enrol51014283_enrol
extol1247893_extol
fool75330593__fool
jewel156711703jew_el
ketol95414003ke_tol
metol75917813me_tol
mewl95618323mew__l
mool67533863__mool
nerol51017813ne_rol
newel86114133new_el
newton936983newton
nonwool1046673nonwool
petrol82714063petrol
peyotl1146233peyotl
pool65835953__pool
precool1139013precool
reboil83814683reboil
rebook125213203rebook
reboot84119333reboot
recoal84117973recoal
recoil84016723recoil
recook125513923recook
redwood1236523redwood
regosol844883regosol
relook104813743relook
reoil55321183re_oil
repoll8410793repoll
reroll6412683reroll
reroof9315003reroof
respool937643respool
retook104313443retook
retools73411023retools
rewoke1339521223rewoke
rewon86920583rew_on
reword106321413reword
rewore938030163rewore
rework136619793rework
reworn98122203reworn
rewove126420083rewove
school11410723school
shool84523153_shool
snool55118643_snool
spool75219043_spool
stool55619893_stool
swoon85014783_swoon
swoop105213433_swoop
tool46735683__tool
uncool8610113uncool
underwool1345013underwool
woo66949803__woo_
wood85329383__wood
woof106532423__woof
wools84421463__wools
wooly114417673__wooly
woos76238803__woos

Search took 6 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 Filter1786911127160.403443402.0
2DLD Change Limit1127161855.50020493.8
3Display Results1851850.0632936.5
 (SQL Overall)1786911855.96629951.6
 
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.