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

346 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
blethers1342961(None) 
blathers134713791blathers
blether12459911blether_
blithers134711231blithers
aethers103614942_aethers
bathers124720362b_athers
beetlers1037392beetlers
belchers153510022belchers
belters93819412belt_ers
bethels1238532b_ethels
betters94422092b_etters
blather125314202blather_
blatters104414092blatters
bleachers16297922bleachers
bleaters103412312bleaters
bleeders11448452bleeders
bleepers12377492bleepers
blenchers16356722blenchers
blenders115210992blenders
blessers10277622blessers
blethered15165432blethered
blither124812172blither_
blitzers19417152blitzers
blotters104110982blotters
bluchers15359032bluchers
blushers133911292blushers
bothers124317752b_others
breathers14319092breathers
brothers133410822brothers
diethers1257452diethers
ethers94518412__ethers
fleshers14339442fleshers
fletchers17335532fletchers
lathers104321882_lathers
leathers114215082_leathers
lechers123313962_lechers
lethes94818082_lethe_s
letters73819852_letters
pleathers1446452pleathers
slathers113914772slathers
slithers114212952slithers
teethers11328712teethers
tethers103815312_tethers
wethers135214692_wethers
abetters1057173abetters
aether94213673_aether_
alterers82512493alterers
alters64924223al_t_ers
altheas1038223al_theas
anthers103715203_anthers
baiters94619303bait_ers
banters94623113bant_ers
barters94223033bart_ers
bashers124820833b_ashers
basters94930303bast_ers
batchers153613273batchers
bather115322513b_ather_
bathes116524833b_athe_s
batters94626013b_atters
battlers104110973battlers
beaders104120183b_eaders
beakers134216873b_eakers
bearers94619593b_earers
beaters94925033b_eaters
beavers124417323b_eavers
bedders113513383b_edders
beeches143413883beeche_s
beepers113612383b_eepers
beers75628393b_e__ers
beetler938033beetler_
beetles9312083beetle_s
beezers18349243b_eezers
begetters12135033begetters
belayers13298143belayers
belcher143511493belcher_
belches143514343belche_s
beliers94617383b_eliers
bellwethers1951433bellwethers
belter84720963belt_er_
beltless10297713beltless
benchers153611013benchers
benders104021063b_enders
besetters11136633besetters
betels84515063b_et_els
bethel1169643b_ethe_l
bethorn1238643b_ethorn
bethorns1337323b_ethorns
beths105519223b_eth__s
better84723703b_etter_
bettors93312473b_ettors
billeters1136863billet_ers
bisters93922603bist_ers
biters83925233b_it_ers
bitters94920353b_itters
blabbers11308153blabbers
bladders12397803bladders
bladers104214683bl_aders
blamers115314213bl_amers
blanchers16307433blanchers
blasters104116143blasters
blathered15168353blathered
blatherer14176713blatherer
blatherers15175343blatherers
blatter94415653blatter_
blazers184811683bl_azers
bleacher15358883bleacher_
bleaches153410673bleache_s
bleaker133510533bleaker_
blears85116453ble__ars
bleater94515303bleater_
bleeder10359643bleeder_
bleeds95211593ble__eds
bleeper11458253bleeper_
bleeps10499103ble__eps
blemishers1763013blemishers
blencher15308393blencher_
blenches153310763blenche_s
blender104613843blender_
blendes104713683blende_s
blesser9329293blesser_
blesses93812393blesse_s
blethering16115933blethering
blets75324943blet___s
blighters1555733blighters
blinders113911143blinders
blinkers14388503blinkers
blisters104015083blisters
blites84721213blit_e_s
blithe115810863blithe__
blithely16104033blithely
blithered15156123blithered
blithest1338083blithest
blitzer18447663blitzer_
blitzes18408703blitze_s
bloaters103311013bloaters
blockers16398793blockers
bloggers12397403bloggers
bloomers12348823bloomers
bloopers12397373bloopers
blotches1537433blotche_s
blotless10347143blotless
blotter94612853blotter_
blowers124313593bl_owers
blubbers11408143blubbers
blucher143310223blucher_
bludgers12397853bludgers
bluffers16405703bluffers
blunders113911333blunders
blungers11469843blungers
blurters10348363blurters
blusher124113113blusher_
blushes124314823blushe_s
blusters104413883blusters
boaters93419233boat_ers
boletes9316063bolet_e_s
bolsters103712443bolst_ers
bolters94017803bolt_ers
botchers153511543botchers
bother115218063b_other_
bottlers103810013bottlers
breachers16369853breachers
breakers143810973breakers
breather133610593breather_
breathes134212903breathe_s
breeders11368893breeders
brethren1343783brethren
breviers1335923breviers
brewers123811053bre_wers
brothels13277073brothels
brother123311333brother_
brushers134210573brushers
bunters94717113bunt_ers
burghers1435633burghers
burthens1335383burthens
bushers124018803b_ushers
busters94724123bust_ers
bustiers103810043bustiers
bustlers104210613bustlers
butchers153710183butchers
butlers94518053b_utlers
butters94521713b_utters
cithers124315753_cithers
clashers134213993clashers
clatters103313903clatters
cleaners103610533cleaners
clearers10349293clearers
cleavers13398863cleavers
clenchers16276553clenchers
clothes124513813clothe_s
clothiers1443423clothiers
clutters103210343clutters
comethers1637433comethers
deters74724683_det_ers
dieters83216423diet_ers
diether1147443diether_
dithers114016153_dithers
druthers1275793druthers
elaters74420183elat_ers
etchers123411293__etchers
ether84518773__ether_
fathers133916503_fathers
feathers143513243feathers
fetchers16328863_fetchers
fetters103517903_fetters
flashers143912653flashers
flatters113814203flatters
fleches153411443fleche_s
fleecers13325933fleecers
fleers96015793fle__ers
flensers1135463flensers
flesher133610923flesher_
fleshes133913273fleshe_s
fletcher16306663fletcher_
fletches16308853fletche_s
flitters114312173flitters
flushers14279733flushers
fluters103713673flut_ers
flutters114010813flutters
flytiers14254483flytiers
fretters113410303fretters
frothers14279803frothers
furthers1436493furthers
gathers114315063_gathers
getters84216093_getters
gleamers11306563gleamers
gleaners9348073gleaners
glitters93710543glitters
heathers143914733heathers
kelters113813753kelt_ers
klezmers2341583klezmers
kvetchers2142373kvetchers
lashers104121833_lashers
lather95124353_lather_
lathery133911123_lathery
lathes95127493_lathe_s
leachers133712813_leachers
leaders83819603_leaders
leakers113415423_leakers
leaners73718173_leaners
leapers93716663_leapers
leasers74717843_leasers
leather103815783_leather_
leathern11398913_leathern
leathery14438973_leathery
leavers103717783_leavers
lecher113415853_lecher_
lechery15257643_lechery
leches115421313_leche_s
ledgers94912173_ledgers
leers54828983_le__ers
legers74518313_le_gers
lehrs86111133_le_h_rs
lenders84419643_lenders
lepers84817323_le_pers
letches124015483_letche_s
lethals1038113_lethals
lethe85717303_lethe__
lethean1037093_lethean
letter63722583_letter_
levers94621323_le_vers
leviers103510343_leviers
liters65429873_lit_ers
lither94520953_lither_
litters73422563_litters
loathers113310433loathers
lotters73921063_lotters
luthern1037653_luthern
lutherns1136293_lutherns
luthiers1135163_luthiers
meeters94714543meet_ers
melters93918313melt_ers
meters85625833_met_ers
metiers93312843_metiers
mithers123516733_mithers
mothers123717623_mothers
mouthers133811303mouthers
muleteers1143673muleteers
murthers1336543murthers
nether94014163_nether_
netters73618583_netters
northers1139333northers
others93918003__others
panthers13510783panthers
pelters93720313pelt_ers
peters86624593_pet_ers
petters93722363_petters
plashers133813453plashers
platers93924083plat_ers
platters103415283platters
pleaders113210183pleaders
pleasers104010293pleasers
pleaters103613783pleaters
pleather1356653pleather_
pledgers12387643pledgers
plethora1344823plethora
plethoras1444793plethoras
plotters104011553plotters
pothers123818623_pothers
reletters9138783reletters
seethes103613743seethe_s
seltzers1735063seltzers
setters73822063_setters
sheathers1557543sheathers
sketchers1834513sketchers
slashers113313603slashers
slaters73123723slat_ers
slather103816063slather_
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
sleighers1343703sleighers
slither104112983slither_
slithery14356703slithery
slitters84014133slitters
slotters84012393slotters
smithers13369793smithers
smothers13349933smothers
soothers113913433soothers
southers114214453southers
swathers144512073swathers
swithers144310533swithers
teeters74018303teet_ers
teether10349693teether_
teethes103611653teethe_s
telphers1335473telphers
tether93716103_tether_
tetters74320473_tetters
tithers104216733_tithers
ulsters72711983ulst_ers
untethers1244153untethers
ureters7311823uret_ers
vetoers10359473_vetoers
vetters104016313_vetters
weathers143412833weathers
welchers16338053welchers
welshers14246813welshers
welters103516063welt_ers
wether123315393_wether_
wetters103817753_wetters
whether16346623whether_
whetters14246653whetters
withers134417753_withers
wreathers15257483wreathers
writhers14398983writhers
wuthers133711523_wuthers
zithers193911973_zithers

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461623466.12323871.0
3Display Results3463460.1432419.6
 (SQL Overall)1786913466.43927751.4
 
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.