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

320 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
donzels173539(None) 
donzel1636311donzel_
bonzes175116102bonze_s
donees74519492don_ees
dongles93212872dongles
donkeys15426662donkeys
donnees84210362donnees
doozers17419292doozers
dorsels84412572dorsels
dossels85511602dossels
dottels8327782dottels
dowels104813342do_wels
dozens164612462do_zens
dozers164815422do_zers
dozes155226302do_ze_s
dynels10536812dyn_els
ouzels15408702_ouzels
rondels82510052rondels
ronnels7318612ronnels
angels74416173_angels
benzols1836673benzols
benzyls2133673benzyls
bezels173712283_bezels
boatels93510233boatels
bonders104120663bonders
boners84825433bon_ers
bones76446533bon_e_s
bonkers134015303bonkers
bonnes85621453bonne_s
bonnets94812803bonnets
bonze165119353bonze__
bonzer175313673bonze_r
boozers183912443boozers
boozes174916523booze_s
bordels103911973bordels
botels84815803bo_tels
bowels114315593bo_wels
bronzers19296983bronzers
bronzes183510403bronze_s
cancels114113313cancels
cannels93413363cannels
compels133210883compels
conceals123111013conceals
cones76457423con_e_s
coneys115218423con_eys
confers124120093confers
confess12399903confess
congeals11309853congeals
congees103517923congees
congers104223233congers
conges94928173conge_s
conies84338593conie_s
conkers133721043conkers
conners94023113conners
consols92914073consols
consuls92412313consuls
contes84432913conte_s
conveys15308223conveys
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
counsels1037573counsels
cozens176314923co_zens
cozes166033243co_ze_s
cozeys204610913co_zeys
cozzes164510893cozze_s
damozels20133163damozels
damsels10126703damsels
danazols1843083danazols
dancers103413093dancers
dances95120653dance_s
danders93921183danders
dandles94218533dandles
dangers94818213dangers
dangles93618423dangles
darnels83710433darnels
dazes155024143d_aze_s
dazzles1636413dazzles
deckels14367363deckels
defuels11296983defuels
dels56745473d___els
denes65639723den_e_s
denials84114133denials
deniers84515183deniers
denies74729643denie_s
denizens1835573denizens
densely1146713densely
dentals83915393dentals
dentils84115583dentils
devels104313903d_evels
diesels8429143diesels
dindles93817243dindles
diners75525953din_ers
dines66449153din_e_s
dingers94321383dingers
dinges83825423dinge_s
dingeys12458403dingeys
dingles93818323dingles
dinkeys15507263dinkeys
dinners83915443dinners
dispels10310503dispels
ditzes163212423ditze_s
dizens164911393d_izens
djebels1753293djebels
dobbers123513253dobbers
dobies94422093dobie_s
dockers143715003dockers
dockets144412243dockets
dodders105511793dodders
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119073dodge_s
dodoes85716103dodoe_s
doers65225713do__ers
does56554473do__e_s
doffers14359853doffers
doges75630163do_ge_s
dogeys115510663do_geys
doggers104413433doggers
doggrels1142633doggrels
dogies85022253dogie_s
doglegs1034783doglegs
doles67843753do_le_s
dolls66126923do__lls
dolmens10388693dolmens
dols56943053do___ls
domes85735563do_me_s
donas65926473don__as
donates83217223donates
done55747913don_e__
donee66931013don_e_e
doneness9411513doneness
dongas84914613don_gas
dongle83612493don_gle
dongola945473dongola
dongolas1045343dongolas
dongs76525813don__gs
donjons1536733donjons
donkey14449733donke_y
donnas75511323don_nas
donne65520463donne__
donned85015743donne_d
donnee74317063donne_e
donnerd9427813donnerd
donnert82815533donnert
donors75115793don_ors
dons56048703don___s
donuts7410583don_uts
doodles93614163doodles
doolees83711613doolees
doozer163910463dooze_r
doozies173812723doozies
dopers95522483do_pers
dopes84935043do_pe_s
dories75232363dorie_s
dormers104313923dormers
dorpers104113173dorpers
dorsals84110843dorsals
dorsel75315503dorsel_
dorsers83516303dorsers
dosers75723633do_sers
doses65938503do_se_s
dossals8379293dossals
dossel74813643dossel_
dossers84516233dossers
dosses76126273dosse_s
dossils8669773dossils
doters74423913do_ters
dotes65836693do_te_s
dottel73610893dottel_
dotters83715973dotters
dottles83912283dottles
dottrels963493dottrels
doubles103113353doubles
doucely1344883doucely
dousers84817273dousers
douses74928933douse_s
dovens104413903do_vens
doves94728153do_ve_s
dowel95618193do_wel_
dowers104523293do_wers
downers113912773downers
downless1236363downless
dowsers115013533dowsers
dowses105718303dowse_s
doxies143917853doxie_s
doyens104810223do_yens
doyleys14384923doyleys
doze145829083do_ze__
dozed165619353do_ze_d
dozen155017473do_ze_n
dozer158419273do_ze_r
dozily19329103do_zily
drivels11397923drivels
droners84114383dron_ers
drones75023433dron_e_s
duels65619233d__uels
duffels14296453duffels
dunces95215753dunce_s
dunes65332173dun_e_s
dunkers123512193dunkers
dunness8298983dunness
dynel9569853dyn_el_
dynes95917583dyn_e_s
fennels10387903fennels
fondles113512613fondles
foozles19329543foozles
funnels10348173funnels
gonefs10439873gon_efs
goners74420173gon_ers
gospels1035593gospels
gunnels8358563gunnels
gunsels8338133gunsels
hansels104011653hansels
hazels185710083_hazels
hondles113614523hondles
honers94324973hon_ers
hones88144493hon_e_s
honeys124016083hon_eys
honkers143315233honkers
honkeys17439513honkeys
hornfels1443783hornfels
hosels94218603ho_sels
hostels103712313hostels
hotels94515513ho_tels
housels105312133housels
hovels125413333ho_vels
ionizers17257713ionizers
ionizes162813343ionize_s
jones125028183jon_e_s
kennels11387193kennels
kneels10408933_kneels
koels94613903ko__els
lintels73311163lintels
lonely92912473lon_ely
loners64225813lon_ers
longers84819543longers
longes75925573longe_s
losels64714583lo_sels
mangels103614493mangels
mantels94515043mantels
models94216353mo_dels
mohels115011323mo_hels
momzers20367133momzers
mondes94322353monde_s
moneys115513623mon_eys
mongers104217273mongers
mongols103310823mongols
mongrels1135333mongrels
monies83233163monie_s
monkeys16407423monkeys
montes84226933monte_s
morels84820013mo_rels
morsels94112653morsels
motels83616893mo_tels
noels56418703__noels
nonces84418833nonce_s
nones55639133non_e_s
nonets64118703non_ets
nonnews1035313nonnews
nonself1078513nonself
nonyls957853non_yls
nonzero1646123nonzero
novels95512503no_vels
nozzles15276303nozzles
ones46146533_on_e_s
onsets64013543_onsets
oozes145418713_ooze_s
oriels64914623_oriels
ousels64815273_ousels
ouzel144612323_ouzel_
panels84716523pan_els
panzers184012013panzers
pencels113610053pencels
podzols1934683podzols
pommels13235783pommels
ponces104720843ponce_s
ponders103618843ponders
pones74547043pon_e_s
pongees104212543pongees
ponies84833463ponie_s
pontes83627853ponte_s
pontils9312213pontils
potzers184010543potzers
rondel73212643rondel_
ronnel63310883ronnel_
roundels9217753roundels
rowels94515453ro_wels
rozzers1535633rozzers
runnels7329153runnels
sonders83820713sonders
sondes74922873sonde_s
sones55444143son_e_s
sonless72612613sonless
sonnets74211993sonnets
sorels63921163so_rels
sorrels7310723sorrels
teazels16406893teazels
tinsels738373tinsels
toners64128003ton_ers
tones56048663ton_e_s
tongers84116013tongers
tonlets73212503tonlets
tonners73816403tonners
tonnes65320853tonne_s
tonsils7310183tonsils
touzles16359223touzles
towels94314643to_wels
tunnels7328723tunnels
vowels124410483vo_wels
winzes184313053winze_s
wonders113315993wonders
wonners104312813wonners
wurzels1934083wurzels
yodels104610073yo_dels
yokels13488063yo_kels
yonkers14379823yonkers
zoners155115993zon_ers
zones145528043zon_e_s
zonules1647793zonules

Search took 7 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.1561145455.1
2DLD Change Limit1340273205.72023431.3
3Display Results3203200.1063018.9
 (SQL Overall)1786913205.98229871.4
 
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.