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

158 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
dowelled135634(None) 
bowelled1446181bowelled
doweled12269771dowe_led
dwelled12337591d_welled
rowelled1236631rowelled
towelled1236351towelled
boweled132810692bowe_led
dolled83518072do__lled
dowered122811552dowe_red
duelled9359752d_uelled
dweller11297272d_weller
hovelled15146842hovelled
jewelled1934342jewelled
modelled1236432modelled
roweled11269862rowe_led
swelled113211702_swelled
toweled112410222towe_led
trowelled1344442trowelled
upwelled1434662upwelled
welled103820212__welled
yodelled1334602yodelled
belled94626193__belled
bevelled14327823bevelled
bolled94722653bo__lled
bowelless1443833bowelless
bowered133113043bowe_red
bowled125018143bow__led
celled94420323__celled
compelled1646133compelled
corbelled1446613corbelled
cordelled1346403cordelled
cowered133214653cowe_red
cowled125218393cow__led
cupelled1365743cupelled
dawdled13376723daw_dled
defuelled1443133defuelled
deled75326543d__e_led
delved114112753d__elved
develed123611933deve_led
devilled1336743devilled
dewooled1333833dewooled
dialled9510133d_ialled
dilled84122223d__illed
disbowelled1852063disbowelled
dispelled13117573dispelled
dogeared1145793dogeared
dogsled1035193do_gsled
doiled84817293do__iled
doled75430913do___led
dollied93811143do_llied
doodled10369463do_odled
doubled11289953do_ubled
dovened12389063dove_ned
dowable13189453dowable_
dowed104632613dow___ed
dowel95618193dowe_l__
doweling13279763doweling
dowelling1466253dowelling
dowels104813343dowe_l_s
doweries12411933doweries
dowerless1344013dowerless
downed115314783dow__ned
downland1364533downland
download1343833download
dowsed115015013dow__sed
dozened18377453doze_ned
drilled94711673d_rilled
drivelled1443983drivelled
drolled93810223d_rolled
drywalled1741833drywalled
dueled84813663d_ue_led
dueller8329833d_ueller
dulled84719423d__ulled
duxelles1643963duxelles
dwell9519853d_well__
dwellers12356083d_wellers
dwells10417713d_well_s
embowelled1852103embowelled
excelled18125703excelled
expelled1895883expelled
felled103720303__felled
fowled133914103fow__led
fuelled11369193_fuelled
gabelled12317583gabelled
gavelled13387363gavelled
gelled84718893__gelled
grovelled1454183grovelled
gruelled1034893gruelled
helled104024703__helled
hostelled1345733hostelled
houselled1346203houselled
hoveled14209293hove_led
howled134014973how__led
impelled1336073impelled
inwalled1275773inwalled
jelled144916063__jelled
jeweled1845333jewe_led
jeweller1844133jeweller
jowled174210803jow__led
knelled12338993_knelled
kvelled15276063_kvelled
labelled11278293labelled
lapelled11227083lapelled
levelled12327453levelled
libelled11317213libelled
lolled74315823lo__lled
lowballed1542053lowballed
lowered112711913lowe_red
melled95023023__melled
modeled1139463mode_led
modeller1136613modeller
morelle91210803morelle_
morelles10710493morelles
morselled1245963morselled
novelle1058233novelle_
panelled1138963panelled
polled94022003po__lled
pommelled1643083pommelled
powered132911643powe_red
propelled1456913propelled
quelled17279273_quelled
ravelled12419783ravelled
rebelled113110333rebelled
refelled122810173refelled
repelled113111593repelled
revelled123712743revelled
rewelded1335893rewelded
rolled74220243ro__lled
roselle7310243roselle_
roselles8310713roselles
shelled113815093_shelled
shovelled16174413shovelled
smelled103511863_smelled
snelled83313053_snelled
spelled103714743_spelled
sweller103012473_sweller
swilled113611833_swilled
tolled73819033to__lled
totalled935843totalled
towered112911403towe_red
troweled12106113trowe_led
troweller1244563troweller
twilled11398033_twilled
umbelled1336273umbelled
unwalled1288653unwalled
unwelded1337143unwelded
unwilled1277823unwilled
upswelled1542903upswelled
vowelized2543473vowelized
walled104021293__walled
welded114013383__welded
welted103715823__welted
willed104722453__willed
woolled1136643wo_olled
yelled104116253__yelled
yodeled1236863yode_led
yodeller1244853yodeller
yowled133811093yow__led

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 Filter1786911461620.466383457.1
2DLD Change Limit1461621587.50319480.5
3Display Results1581580.0602633.3
 (SQL Overall)1786911588.02922255.7
 
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.