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

246 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
roundel830885(None) 
rondel73212641ro_ndel
rounded93013501rounded
roundels9217751roundels
rounder83514601rounder
bounded113613762bounded
bounden10389452bounden
bounder104215532bounder
counsel948542counsel
founded124011422founded
founder114312572founder
grounded1136572grounded
grounder1047612grounder
groundsel1142782groundsel
hounded123311032hounded
hounder113412232hounder
mounded113711982mounded
poundal1036402poundal
pounded114112792pounded
pounder103314002pounder
rondels82510052ro_ndels
ronnel63310882ro_nnel
round64318432round__
roundelay1342722roundelay
rounders92613692rounders
roundest9310472roundest
roundheel1342742roundheel
roundlet9209222roundlet
roundly1136722roundly
rounds73615622round_s
roundup1044062roundup
rundle73214232r_undle
runnel63510662r_unnel
sounded93214462sounded
sounder83315382sounder
wounded12329762wounded
abounded1234903abounded
aludel747863alu_del
around72712413around__
asunder856223asunder
blunder103813153blunder
bonded104719953bo_nded
bonder95324783bo_nder
bordel94514573bo_rdel
boulder103411343boulder
bounce104014833bounce_
bounced123610553bounced
bouncer113811333bouncer
bounces113813683bounces
bound84819583bound__
bounders114314113bounders
bounds94415803bound_s
bundle94315573_bundle
chunnel12395303chunnel
cornel84020053corn_el
coude85022633cou_de_
council1137473council
counsels1037583counsels
counted103815803counted
counter94220153counter
daunder9348893daunder
donzel1636313do_nzel
drownded14334433drownded
flounder1235103flounder
fonded115717043fo_nded
fonder104120063fo_nder
fondle104412943fo_ndle
found94917843found__
founders123911673founders
foundry1433913foundry
founds104814193found_s
fronded12388863fro_nded
frounce1236153frounce_
frounced1434493frounced
frounces1336183frounces
funded114413893_funded
funder104016083_funder
funnel93610743_funnel
gourde8107933gourde_
gourdes9109383gourdes
ground82310273ground__
grounders1156783grounders
grounds9228313ground_s
groundsels1242383groundsels
gunnel73411053_gunnel
gunsel7339853_gunsel
hondle103914523ho_ndle
hound95016483hound__
hounders123111713hounders
hounds104413133hound_s
housel95217053hou_sel
joinder15337593joinder
jounce153310733jounce_
jounced17337613jounced
jounces16369853jounces
launder8309143launder
louden73711793lou_den
louder74414603lou_der
lounge75211213lounge_
lounged9468243lounged
lounger84610213lounger
lounges84811353lounges
maunder10328683maunder
model84521693mo__del
monde85723143mo_nde_
mondes94322353mo_ndes
moulded11348063moulded
moulder10389803moulder
mound83918313mound__
mounds93915133mound_s
mounted103611533mounted
mounter93713173mounter
nounal639813noun_al
ounce77019933_ounce_
ounces83617773_ounces
ousel55222403_ou_sel
outduel837303_outduel
ouzel144612323_ou_zel
plunder103810503plunder
poinded11358973poinded
ponded105218773po_nded
ponder94521693po_nder
pounce105214093pounce_
pounced123510623pounced
pouncer113511233pouncer
pounces114113893pounces
pound84417863pound__
poundals1145013poundals
pounders113113283pounders
pounds93714383pound_s
prouder10310383prou_der
rebounded1335463rebounded
rebounder1245103rebounder
redounded1235263redounded
refounded1435473refounded
refunded1336953refunded
refunder1236503refunder
reindex1536093reindex
remodel1038093remodel
rended84524103r_ended
render74024143r_ender
resounded1136323resounded
rinded84418983r_inded
roadeo7510323ro_adeo
rodded93713703ro_dded
rode55844303ro__de_
rodeo65921093ro__deo
rodes614039083ro__des
rondeau846813ro_ndeau
rondelet9410353ro_ndelet
rondelle946813ro_ndelle
rondo65218373ro_nd_o
rondos74616733ro_ndos
ronnels7318613ro_nnels
rotund737293rotund__
rotunda843943rotund_a
rotundas943573rotundas
rotundly1243433rotundly
rouble83913313rouble_
roubles93413513roubles
rouche114714313rouche_
rouches124217893rouches
roue45941743rou__e_
rouen54920903rou__en
roues56039353rou__es
rouge65423443rou_ge_
rouged86717323rou_ged
rouges76022383rou_ges
roughed124210943roughed
roughen11338833roughen
rougher113511033rougher
rouille737493rouille
roulade857003roulade_
roulades957173roulades
roundball1243313roundball
roundelays1451993roundelays
roundheels1452023roundheels
rounding102812283rounding
roundish1246253roundish
roundlets10175293roundlets
roundness1047013roundness
roundsmen1243823roundsmen
roundups1143593roundups
rouped95717353rou_ped
roupet84218343rou_pet
roupier9319493roupier
rouse56634703rou_se_
roused75426443rou_sed
rouser65224083rou_ser
rouses65436283rou_ses
rousted84013323rousted
rouster73517083rouster
route55132073rou_te_
routed75624333rou_ted
router65025843rou_ter
routes66129313rou_tes
rowel84721413ro__wel
rubel75416833r_u_bel
rudder83812803r_udder
ruddle83414203r_uddle
rude55632783r_u_de_
rudely10389973r_u_dely
ruder65320543r_u_der
rundles83214713r_undles
rundlet83114153r_undlet
rune45236303r_un_e_
runes55530223r_un_es
runkle103611543r_unkle
runlet63821413r_unlet
runnels7329153r_unnels
runner63814463r_unner
scoundrel1241973scoundrel
sonde64622833so_nde_
sonder73623523so_nder
sondes74922873so_ndes
sound64420023sound__
sounders93214113sounders
soundest9510973soundest
soundly1136683soundly
soundmen1145233soundmen
sounds74616183sound_s
stounded10276213stounded
sunder74019823_sunder
sundew10369693_sundew
swounded13314563swounded
thunder1136963thunder
trounce936823trounce_
trounced1135033trounced
trouncer1035443trouncer
trounces1037063trounces
trundle8307873trundle
trunnel745403trunnel
tunnel64310633_tunnel
unde55825483__unde_
undee65327273__undee
under64624213__under
unrounded1135863unrounded
wonder103617813wo_nder
wound94414213wound__
woundedly1742243woundedly
wounds103811633wound_s
yodel94714083yo__del
yonder103214133yo_nder
younger11387163younger
younker14316453younker
zounds164310173zound_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272466.64020184.8
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.13925030.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.