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

155 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
dewools114559(None) 
dewool1047401dewool_
befools1236432befools
dewooled1333832dewooled
deworms1338022deworms
drools74412812d_rools
dyewoods1643502dyewoods
retools73411022retools
wools84421462__wools
aerosols847213aerosols
awols84713523_aw_ols
babools11319453babools
befool1137713befool_
befouls1236053befouls
behowls1534443behowls
benzols1836673benzols
bewails1277553bewails
beworms1437923beworms
ceorls848163ce_orls
cools75632633__cools
dagwoods1444583dagwoods
dahoons1137753dahoons
deacons10310393deacons
deadwoods1544313deadwoods
deals65435343de__als
debones103315113debones
debtors1038533debtors
decals93717713de_cals
deckels14367363deckels
decocts1237833decocts
decodes113914983decodes
decolor1087033decolor
decolors1187713decolors
decorous1138853decorous
decors94017773de_cors
decos85522123de_co_s
decoys123911283de_coys
defoams1336193defoams
defocus1335283defocus
defogs1156683de_fogs
deforms1337803deforms
defuels11296983defuels
dehorns11428363dehorns
dehorts11379773dehorts
deils65722863de__ils
dekkos1034103dekko_s
dells66630943de__lls
dels56745473de___ls
demobs11429483de_mobs
demons94917723de_mons
demos86022993de_mo_s
demoses103815823demoses
demotes104717673demotes
denials84114133denials
denotes83817003denotes
dentals83915393dentals
dentils84115583dentils
deploys1336523deploys
depones103717093depones
deports105012883deports
deposals1145433deposals
deposes103117213deposes
depots94716343de_pots
derails84216393derails
desorbs10437713desorbs
despoils1145623despoils
despots10319683despots
details84214043details
detours858043detours
detoxes1538803detoxes
devels104313903de_vels
devils104412813de_vils
devious1138523devious
devoirs1175783devoirs
devons104512253de_vons
devotes113713753devotes
devours1166643devours
dewans105215143dew_ans
dewars105117073dew_ars
dewaxes18297843dewaxes
dewdrops1542963dewdrops
dewfall1453763dewfall
dewfalls1543073dewfalls
dewily1338343dew_ily
dewlaps1334663dewlaps
dewless1137473dewless
dewooling1444323dewooling
deworm1249523dew_orm
dews86230603dew___s
dhooly13457143d_hooly
diobols1036543diobols
diols65521013d__iols
dogwoods1454483dogwoods
dolls66126923d__olls
dols56943053d___ols
dooly94821803d__ooly
dooms85321343d__ooms
doors65022133d__oors
doowops1363943doowops
dowels104813343dow_els
drolls75312393d_rolls
drool65416103d_rool_
drooly104911073d_rooly
droops95110963d_roops
dwells10417713d_wells
dyewood1554143dyewoo_d
ebooks12358333_ebooks
enols54718403_e_nols
enrols61213383_enrols
extols1337683_extols
fools86824203__fools
jewels16508613jew_els
ketols104210763ke_tols
metols84115773me_tols
mewls105813233mew__ls
mools76027173__mools
nerols6914883ne_rols
newels93710823new_els
newtons1036813newtons
petrols92913083petrols
peyotls1233633peyotls
pools74427703__pools
precools1237703precools
reboils94111723reboils
rebooks134010513rebooks
reboots93512093reboots
recoals94214623recoals
recoils93814873recoils
recooks134711233recooks
redwoods1345773redwoods
regosols944323regosols
relooks114010723relooks
reoils64516873re_oils
repolls939053repolls
rerolls739943rerolls
reroofs1037943reroofs
respools1036243respools
retool63914483retool_
rewords115413973rewords
reworks145113593reworks
schools1249113schools
shools94919013_shools
snools65715883_snools
spools85115913_spools
stools65117023_stools
swoons94511143_swoons
swoops114910923_swoops
tools55325243__tools
underwools1444433underwools
woods95723033__woods
woofs114918003__woofs
wool76427373__wool_
wooly114417673__wooly
woops104917523__woops
woos76238803__woo_s

Search took 9 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.1401276364.3
2DLD Change Limit1340271558.42315912.0
3Display Results1551550.0463369.6
 (SQL Overall)1786911558.60920756.3
 
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.