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

180 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
roundels921774(None) 
rondels82510051ro_ndels
roundel8308851roundel_
rounders92613681rounders
bounders114314102bounders
counsels1037572counsels
founders123911662founders
grounders1156772grounders
groundsels1242372groundsels
hounders123111702hounders
poundals1145012poundals
pounders113113262pounders
rondel73212642ro_ndel_
ronnels7318612ro_nnels
rounded93013502rounde_d
roundelay1342722roundelay
roundelays1451992roundelays
rounder83514592rounde_r
roundest9310472roundest
roundheels1452022roundheels
roundlet9209222roundlet
roundlets10175282roundlets
roundly1136722round_ly
roundness1047002roundness
rounds73615612round__s
roundups1143582roundups
rundles83214712r_undles
runnels7329152r_unnels
sounders93214102sounders
aludels835293alu_dels
blunders113911333blunders
bonders104120663bo_nders
bordels103911973bo_rdels
boulders113010023boulders
bouncers12309353bouncers
bounces113813683bounce_s
bounded113613763bounde_d
bounden10389453bounde_n
bounder104215533bounde_r
boundless1235183boundless
boundness1235943boundness
bounds94415803bound__s
bundles103515773_bundles
chunnels13304553chunnels
cornels94716663corn_els
councils1246973councils
counsel948543counsel_
counters103320183counters
countess103710043countess
daunders10278473daunders
donzels1735393do_nzels
flounders1374603flounders
fondles113512613fo_ndles
founded124011423founde_d
founder114312563founde_r
founds104814193found__s
frounces1336183frounce_s
funders113813933_funders
funnels10348173_funnels
gourdes9109383gourde_s
grounded1136573grounde_d
grounder1047603grounde_r
groundless1243463groundless
grounds9228303ground__s
groundsel1142783groundsel_
gunnels8358563_gunnels
gunsels8338133_gunsels
hondles113614523ho_ndles
hornfels1443783hornfels
hounded123311033hounde_d
hounder113412233hounde_r
hounds104413133hound__s
housels105312133hou_sels
joinders16337203joinders
jounces16369853jounce_s
launders9358743launders
loudens8368053lou_dens
loudness937013loudness
loungers9449003loungers
lounges84811353lounge_s
maunders11348343maunders
models94216353mo__dels
mondes94322353mo_nde_s
moulders11348333moulders
mounded113711983mounde_d
mounds93915133mound__s
mounters103712493mounters
nounless837253nounless
ounces83617773_ounce_s
ousels64815273_ou_sels
outduels945053_outduels
ouzels15408703_ou_zels
plunders11329823plunders
ponders103618843po_nders
pouncers12349203pouncers
pounces114113893pounce_s
poundal1036403poundal_
pounded114112793pounde_d
pounder103313993pounde_r
pounds93714383pound__s
proudness1246683proudness
rebounders1343933rebounders
refunders1334973refunders
remodels1135663remodels
renders83821673r_enders
roadeos837403ro_adeos
rodeos75314503ro__deos
rodes614039083ro__de_s
rondeau846813ro_ndeau
rondelet9410353ro_ndelet
rondelets1045263ro_ndelets
rondelle946813ro_ndelle
rondelles1046623ro_ndelles
rondos74616723ro_nd_os
ronnel63310883ro_nnel_
rotundas943573rotund_as
rotundly1243433rotund_ly
rotundness1143403rotundness
roubles93413503rouble_s
rouches124217893rouche_s
rouens64814443rou__ens
roues56039353rou__e_s
rouges76022383rou_ge_s
roughens12286893roughens
roughers12329173roughers
rouilles837183rouilles
roulades957163roulade_s
round64318433round___
roundball1243313roundball
roundballs1352763roundballs
roundheel1342743roundheel
rounding102812283rounding
roundish1246253roundish
roundup1044053round_up
rousers75220133rou_sers
rouses65436283rou_se_s
rousters84315653rousters
routers74822853rou_ters
routes66129313rou_te_s
rowels94515453ro__wels
rubels84112993r_u_bels
rudders93210643r_udders
ruddles92813873r_uddles
rudely10389973r_u_dely
rundle73214233r_und_le
rundlet83114153r_undlet
rundlets9307363r_undlets
runes55530223r_un_e_s
runkles114111943r_unkles
runless72810423r_unless
runlets73310773r_unlets
runnel63510663r_unnel_
runners74212453r_unners
scoundrels1341503scoundrels
sonders83820713so_nders
sondes74922873so_nde_s
sounded93214463sounde_d
sounder83315383sounde_r
soundest9510973soundest
soundless1035533soundless
soundly1136683sound_ly
soundness1036963soundness
sounds74616183sound__s
sunders84120053_sunders
sundews11398153_sundews
thunders1236943thunders
trouncers1134793trouncers
trounces1037053trounce_s
trundles9278473trundles
trunnels844513trunnels
tunnels7328723_tunnels
wonders113315993wo_nders
wounded12329763wounde_d
woundedly1742243woundedly
woundless1334033woundless
wounds103811633wound__s
yodels104610073yo__dels
youngers12336933youngers
younkers15295763younkers
zounds164310173zound__s

Search took 10 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.1701051123.5
2DLD Change Limit1461621809.19015904.5
3Display Results1801800.0762368.4
 (SQL Overall)1786911809.43618937.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.