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

341 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
clowders1435747(None) 
chowders17387531chowders
clowder13367931clowder_
crowders14398791crowders
blowers124313592blow_ers
chowder16387802chowder_
clawers123910962claw_ers
clobbers14397512clobbers
clockers16369812clockers
cloggers12437282cloggers
cloners94514822clo_ners
closers94415312clo_sers
clouters10399792clouters
clovers125114662clo_vers
clownery1633312clownery
codders114114442c_odders
coders95426972c_o_ders
corders104520872c_orders
cowers114625532c_ow_ers
crowder13389842crowder_
crowers124614892crow_ers
crowners133710742crowners
flooders12257832flooders
flowers133413172flow_ers
glowers113412092glow_ers
loaders83413412_loaders
lowers94624922_low_ers
plodders1235522plodders
plowers123812242plow_ers
powders134111552_powders
scowders14276212scowders
accorders14144113accorders
alders74218423al__ders
avoiders1254783avoiders
avowers1336333avow_ers
bladders12397803bladders
bladers104214683bl_aders
bleeders11448453bleeders
blenders115210993blenders
blinders113911143blinders
bloaters103311013bloaters
blockers16398793blockers
bloggers12397403bloggers
blonder104011943blonder_
blondes104213163blonde_s
bloomers12348823bloomers
bloopers12397373bloopers
blotters104110983blotters
blower115316573blow_er_
blowier1248943blowier_
blunders113911333blunders
bonders104120663_bonders
borders104317533_borders
bowers115523703_bow_ers
bowlders14306493_bowlders
bowlers123715783_bowlers
bowyers15438733_bowyers
broiders114211183broiders
brooders112610233brooders
browsers13449193browsers
calenders1237403calenders
caloyers1337343calo_yers
carders104820353c_arders
ceders93817673c__eders
chawers154412033chaw_ers
cheders134512393c_heders
chewers154111133chew_ers
chiders135312943c_hiders
chokers164311513cho_kers
cholers124215193cho_lers
chompers17369573chompers
choosers134810863choosers
choppers174110453choppers
chousers134610183chousers
chowdered1944003chowdered
chowses155611283chowse_s
chudders15235553chudders
ciders94620083c__iders
cinders104617753c_inders
clabbers14359893clabbers
clackers163911703clackers
clades94920463cl_ade_s
claimers12298743claimers
clambers144211283clambers
clammers143510683clammers
clampers143211883clampers
clangers114312343clangers
clappers143310833clappers
claquers19226193claquers
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313903clatters
clavers124314893cl_avers
claviers1367103claviers
clawer114512783claw_er_
clawless1334123clawless
cleaners103610533cleaners
clearers10349293clearers
cleavers13398863cleavers
clickers163910203clickers
climbers14318403climbers
clingers113810653clingers
clinkers14339833clinkers
clippers14368833clippers
clivers123411753cl_ivers
clobber13378163clobber_
cloches144113713cloche_s
clocker153910873clocker_
cloddier1234063cloddier_
clods85320863clo_d__s
clogger11438803clogger_
cloisters1137413cloisters
cloner84418093clo_ner_
clones84526563clo_ne_s
cloques18268563cloque_s
closer84918203clo_ser_
closes85425593clo_se_s
closets94611603clo_sets
closures10228943closures
clothes124513813clothe_s
clothiers1443423clothiers
clotures10299023clotures
clouded11348833cloude_d
cloudier1135053cloudier_
cloudless1243153cloudless
cloudlets1242823cloudlets
clouds94612353cloud__s
clours85215083clo__urs
clouter93511683clouter_
clover114617123clo_ver_
clovery15407403clo_very
cloves114918823clo_ve_s
clowned13447723clowne_d
clowneries1544733clowneries
clowns114810113clow__ns
clozes174915563clo_ze_s
clubbers14378573clubbers
clumbers143910393clumbers
clunkers14327543clunkers
clusters102912393clusters
clutters103210343clutters
clysters13227823clysters
coalers94419333c_oalers
coaters93525773c_oaters
coaxers164311063c_oaxers
cobbers134114753c_obbers
cockers153618333c_ockers
codder104416333c_odder_
coddlers12359163c_oddlers
codecs115112933c_o_decs
codens94821013c_o_dens
coder86134213c_o_der_
codes86247293c_o_de_s
codgers115113923c_odgers
coffers154112693c_offers
coholders1535613coholders
coilers93619903c_oilers
coiners93620753c_oiners
colanders1238013colanders
colder95121833c_older_
coleaders1237803coleaders
colliders12298073colliders
colliers103613583colliers
colluders12285613colluders
colorers10312183colorers
colourers1136473colourers
colters93522433c_olters
combers134516613c_ombers
comers105328083c_o_mers
condors104018553c_ondors
confers124120093c_onfers
congers104223233c_ongers
conkers133721043c_onkers
conners94023113c_onners
cooers84324563c_o_oers
cookers134619463c_ookers
coolers93522493c_oolers
coopers114019483c_oopers
cooters94525713c_ooters
copers104629843c_o_pers
copiers114215963c_opiers
coppers133519753c_oppers
copters113621273c_opters
corder94322873c_order_
corers85231073c_o_rers
corkers134118853c_orkers
corners94723313c_orners
coshers123618173c_oshers
costers94128303c_osters
cotters94323433c_otters
couters93827283c_outers
covers114627963c_o_vers
cower104531773c_ow_er_
cowherb1735103c_owherb
cowherbs1833543c_owherbs
cowherd1636953c_owherd
cowherds1735423c_owherds
cowier113616163c_owier_
cowpeas1437273c_owpeas
crawlers13309003crawlers
croakers14288503croakers
crofters13358893crofters
crooners103911393crooners
croppers143311483croppers
crosiers103312053crosiers
crossers103912693crossers
crowbars1544423crowbars
crowded14418783crowde_d
crowdies1437543crowdies
crowds124910763crowd__s
crower114117553crow_er_
crowner124012593crowner_
crownets13407673crownets
crozers184111083cro_zers
croziers19287003croziers
cyders12398833c__yders
cylinders1543203cylinders
dodders105511793_dodders
dowers104523293_dow_ers
downers113912773_downers
dowsers115013523_dowsers
drowners12428273drowners
elders74817303el__ders
elodeas836963elo_deas
eloiners8128153eloiners
elopers95112943elo_pers
eluders8409903el_uders
flinders12439263flinders
floaters112711503floaters
floggers13387863floggers
flooder11258463flooder_
floorers11227573floorers
floppers15337463floppers
flossers11307863flossers
flounders1374603flounders
flouters11419263flouters
flower124815503flow_er_
flowerers1544503flowerers
flowery16327783flow_ery
fodders124010753_fodders
folders113514393_folders
fowlers133411203_fowlers
frowners14377933frowners
glanders103811503glanders
gliders94811843gl_iders
gloaters9288853gloaters
glossers9319053glossers
glovers114310883glo_vers
glower105114933glow_er_
growers113612723grow_ers
growlers12327093growlers
holders113715903_holders
howlers133312353_howlers
knowers1436333know_ers
ladders94115173_ladders
laders74927763_l_aders
landers84026213_landers
larders83516943_larders
lauders84012893_lauders
lawyers13377153_lawyers
leaders83819603_leaders
lenders84419643_lenders
lewder10479613_lewder_
loader74316303_loader_
loafers10349463_loafers
loaners73913623_loaners
lobbers113713933_lobbers
lockers133516923_lockers
lodens74315063_lo_dens
lodes66436913_lo_de_s
lodgers95113833_lodgers
lofters103912903_lofters
loggers94616133_loggers
loiters74116613_loiters
lollers72713793_lollers
loners64225803_lo_ners
longers84819533_longers
lookers114014073_lookers
loopers93914033_loopers
looters74419163_looters
lopers84424143_lo_pers
loppers113014103_loppers
losers65123583_lo_sers
lotters73921063_lotters
loudens8368053_loudens
louder74414603_louder_
louvers10359103_louvers
lovers94223433_lo_vers
lower85830413_low_er_
lowery124112703_low_ery
lowes85732463_low_e_s
lowness1037813_lowness
lowriders1343183_lowriders
molders103315553_molders
mowers113219403_mow_ers
nodders94410253_nodders
orders74315993__orders
owners94210703__owners
pleaders113210183pleaders
plodder1146003plodder_
plotters104011553plotters
plovers123611833plo_vers
plower114315063plow_er_
plunders11329823plunders
polders103617373_polders
ponders103618843_ponders
powder123611903_powder_
powdery16396123_powdery
powers113822323_pow_ers
powters124015653_powters
prodders1237453prodders
prowlers13328933prowlers
reloaders1036413reloaders
reorders9198833reorders
rowers94924573_row_ers
scolders11288993scolders
scowder13286853scowder_
scowlers13257343scowlers
showers134612663show_ers
slanders94014013slanders
sledders10257373sledders
sliders83515223sl_iders
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093slo_pers
slotters84012393slotters
slower94016153slow_er_
slowness1135013slowness
smolders11287193smolders
solders83517773_solders
sonders83820713_sonders
sowers94923433_sow_ers
towers94423673_tow_ers
trowsers11427983trowsers
unloaders1044403unloaders
voiders11279823_voiders
vowers124317183_vow_ers
wonders113315993_wonders
wowsers13488753_wowsers
yowlers13328923_yowlers

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.1561145455.1
2DLD Change Limit1461623417.89018525.0
3Display Results3413410.1402435.7
 (SQL Overall)1786913418.18621828.9
 
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.