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

297 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
blessers1027762(None) 
blesser9329291blesser_
blesses93812391blesse_s
blasters104116142blasters
bleaters103412312bleaters
bleeders11448452bleeders
bleepers12377492bleepers
blenders115210992blenders
blessed10319492blesse_d
blethers13429612blethers
blisses94911512blisse_s
blisters104015082blisters
blushers133911292blushers
blusters104413882blusters
classers104111832classers
dressers9359862dressers
flensers1135462flensers
fleshers14339442fleshers
flossers11307862flossers
glossers9319052glossers
guessers9174892guessers
leasers74717842_leasers
lessees73510242_lessees
lessens7409382_lessens
lesser63514852_lesser_
lessors73610522_lessors
pleasers104010292pleasers
plessors10278252plessors
pressers103215022pressers
abbesses1235333abbesse_s
amassers10337833amassers
balusters1136633balusters
bashers124820833b_ashers
basses85428303b_asse_s
bassets96414823b_assets
basters94930303b_asters
beaders104120183b_eaders
beakers134216873b_eakers
bearers94619593b_earers
beaters94925033b_eaters
beavers124417323b_eavers
bedders113513383b_edders
beepers113612383b_eepers
beers75628393b_e__ers
beetlers1037393beetlers
beezers18349243b_eezers
belayers13298143belayers
belchers153510023belchers
beliers94617383b_eliers
belters93819413b_elters
benders104021063b_enders
berserk1334913b_erserk
berserks1433993b_erserks
beseems1175913b_eseems
beses75830723b_e_se_s
besets85718803b_e_sets
besmears1234543b_esmears
bestirs9311133b_estirs
betters94422093b_etters
biasses94911653biasse_s
bimesters1336323bimesters
bisters93922603b_isters
blabbers11308153blabbers
bladders12397803bladders
bladers104214683bl_aders
blamers115314213bl_amers
blaster94017303blaster_
blathers134713793blathers
blatters104414093blatters
blazers184811683bl_azers
bleachers16297923bleachers
bleaker133510533bleaker_
blears85116453ble__ars
bleater94515303bleater_
bleeder10359643bleeder_
bleeds95211593ble__eds
bleeper11458253bleeper_
bleeps10499103ble__eps
blemishers1763013blemishers
blenchers16356723blenchers
blender104613843blender_
blendes104713683blende_s
blesboks1643033blesboks
bless75917813ble_s__s
blesseder1252483blesseder
blessedest1352393blessedest
blessedly1542213blessedly
blessing1137593blessing
blessings1233723blessings
blether12459913blether_
blinders113911143blinders
blinkers14388503blinkers
blissed10388373blisse_d
blissless1142623blissless
blister94415313blister_
blistery13418713blistery
blithers134711233blithers
blitzers19417153blitzers
bloaters103311013bloaters
blockers16398793blockers
bloggers12397403bloggers
bloomers12348823bloomers
bloopers12397373bloopers
blossoms12134543blossoms
blotters104110983blotters
blouses94014463blouse_s
blowers124313593bl_owers
blubbers11408143blubbers
bluchers15359033bluchers
bludgers12397853bludgers
bluesier1034943bluesier_
bluestems1342223bluestems
bluffers16405703bluffers
blunders113911333blunders
blungers11469843blungers
blurters10348363blurters
blusher124113113blusher_
blushes124314823blushe_s
bluster94215313bluster_
blustery13368003blustery
boasters103915653boasters
bolsters103712443bolsters
boosters104013433boosters
bosses85925403b_osse_s
brasiers103710513brasiers
brasses93818353brasse_s
breakers143810973breakers
breeders11368893breeders
breviers1335923breviers
brewers123811053bre_wers
brisses94314313brisse_s
browsers13449193browsers
bruisers10307953bruisers
brushers134210573brushers
bursters1038983bursters
bushers124018803b_ushers
buskers133414083b_uskers
busses85023383b_usse_s
busters94724123b_usters
caressers1137433caressers
censers94313903_censers
cesses84221363_cesse_s
chesses124112633chesse_s
clashers134213993clashers
claspers124410913claspers
classer93614613classer_
classes94717943classe_s
cleaners103610533cleaners
cleansers11335063cleansers
clearers10349293clearers
cleavers13398863cleavers
closers94415313cl_osers
clusters102912393clusters
clysters13227823clysters
colessees11146043colessees
colessors1145663colessors
creasers103612813creasers
cresses94219813cresse_s
cressets10309103cressets
crossers103912693crossers
cussers94213393_cussers
dessert82916453_dessert
desserts9247923_desserts
diesters92513593diesters
dossers84516233_dossers
dresser83611953dresser_
dresses83716173dresse_s
eskers105312223__eskers
esses56422973__esse_s
esters64627733__esters
fesses94820253_fesse_s
festers104121393_festers
flashers143912653flashers
fleecers13325933fleecers
fleers96015793fle__ers
flenser1036783flenser_
flenses1039473flense_s
flesher133610923flesher_
fleshes133913273fleshe_s
flosser10339693flosser_
flosses103411973flosse_s
flushers14279733flushers
flusters113811493flusters
fussers104210813_fussers
gassers84714633_gassers
geysers1135703_geysers
glasses84414273glasse_s
gleamers11306563gleamers
gleaners9348073gleaners
glisters93912603glisters
glosser83410813glosser_
glosses84014123glosse_s
greasers93410253greasers
grossers94410973grossers
guesser8166543guesser_
guesses8169373guesse_s
hissers104112313_hissers
idlesses936003idlesse_s
ileuses738673ileuse_s
jesses135215953_jesse_s
jesters144118193_jesters
keesters12319593keesters
kiesters123310143kiesters
kissers114211293_kissers
klezmers2341583klezmers
klisters123910483klisters
knessets1243173knessets
lapsers93911053_lapsers
lasers64925703_l_asers
lashers104121833_lashers
lasses64827593_lasse_s
lassoers8338513_lassoers
lasters75627693_lasters
leaders83819603_leaders
leakers113415423_leakers
leaners73718173_leaners
leapers93716663_leapers
leaser65322673_leaser_
leases65428113_lease_s
leavers103717783_leavers
lechers123313963_lechers
ledgers94912173_ledgers
leers54828983_le__ers
legers74518313_le_gers
leisters83312823_leisters
lenders84419643_lenders
lenses64620893_lense_s
lepers84817323_le_pers
leses54930813_le_se_s
lessee64116363_lesse_e
lessen64212433_lesse_n
lessons73811013_lessons
lessor64010603_lessor_
letters73819853_letters
levers94621323_le_vers
leviers103510343_leviers
lispers94514323_lispers
listers74026523_listers
loesses7310033loesse_s
losers65123583_l_osers
losses65925233_losse_s
lusters73921433_lusters
messes84924343_messe_s
molesters1198873molesters
mossers94116193_mossers
nesses64718323_nesse_s
nesters74422783_nesters
noblesses1145993noblesse_s
obsesses1036223obsesse_s
obsessors1142883obsessors
oldsters996733oldsters
oleasters936733oleasters
oyesses1037333oyesse_s
passers94717753_passers
pesters93827093_pesters
pissers95014753_pissers
plashers133813453plashers
plasters103518133plasters
pleaders113210183pleaders
pleaser93912343pleaser_
pleases94515483please_s
pleaters103613783pleaters
pledgers12387643pledgers
plessor9317693plessor_
plisses94411773plisse_s
plusses93510693plusse_s
presser93717623presser_
presses93523153presse_s
pressors103212673pressors
presters103419003presters
questers17168763questers
releasers937323releasers
resters74130403_resters
seisers73816393_seisers
slashers113313603slashers
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
sublessees1244583sublessees
sublessors1243363sublessors
teasers75317243_teasers
tessera736333_tessera
testers74124543_testers
tossers74713493_tossers
tressels8367653tressels
tresses73719543tresse_s
trussers8348263trussers
tussers74313563_tussers
ulsters72711983ul_sters
versers103813513_versers
vespers1239033_vespers
vessels1035933_vessels
welshers14246813welshers
westers105221963_westers
wresters112711733wresters
yesses93615813_yesse_s
zesters163517293_zesters

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 Limit1461622978.15617920.8
3Display Results2972970.1102700.0
 (SQL Overall)1786912978.42221217.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.