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

457 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
lobster928885(None) 
lobsters10268731lobsters
mobster11299211mobster
boaster94616432boaster
bolster93713422bolster
booster94314552booster
cloister1037092cloister
coaster94219032coaster
coster84331292co_ster
dabster1036702dabster
fibster12146532fibster
foster94322222fo_ster
hoister103714202hoister
holster103512212holster
jouster143311042jouster
lamster9109912lamster
laster64830632l_aster
leister73212752leister
lister64527252l_ister
lobate82915242lobate_
lobated102610942lobated
lobber104016592lob_ber
lobbyer1433912lobbyer
lobstered1244632lobstered
lobsterer1144032lobsterer
locater93113602locater
lofter94614722lo_fter
loiter64619172lo_iter
looser65219942loos_er
looter64222322lo_oter
loser54728672lo_s_er
lotter64025602lo_tter
lousier72411622lousier
luster64023672l_uster
mobsters12359052mobsters
moister94015372moister
monster93214592monster
oldster896572oldster
ouster64223732_ouster
oyster94111702_oyster
poster84129172po_ster
roaster74116662roaster
robuster1035662robuster
roister73516202roister
rooster74415172rooster
roster64329082ro_ster
rouster73517082rouster
royster103110532royster
toaster74414462toaster
webster1236092webster
zoster153715852zo_ster
abater85518123_abater
aborter939923aborter
alabaster1143353alabaster
arbiter939933arbiter
aster55434893__aster
baster85333593_baster
bister84922763_bister
biter75030033__biter
blaster94017303blaster
blister94415313blister
bloater94013423blo_ater
blotter94612853blo_tter
blousier1055663blousier
blowsier1335063blowsier
bluster94215313bluster
boasted104113743boasted
boasters103915653boasters
boater84622093bo_ater
bobber95016743bob_ber
bobsled12297153bobsled
bobstay1443983bobstay
bolsters103712443bolsters
bolter83920753bo_lter
bombaster1543803bombaster
boosted104111983boosted
boosters104013433boosters
bosker123813653bo_sker
bossier93712423bossier
burster9310293burster
buster84726493_buster
caster85232573_caster
chaster124718503chaster
clobber13378163clob_ber
cloisters1137413cloisters
closer84918203clo_s_er
clouter93511683clo_uter
cluster94013323cluster
clyster12317453clyster
coasted104015943coasted
coasters104317303coasters
coater84329553co_ater
cobber124116843cob_ber
cobbier133410163cobbier
cobbler133311823cobbler
cointer93616723cointer
colter84625093co_lter
combater1439373combater
cooter85128613co_oter
copter109822013co_pter
cosher114819903co_sher
cosier84423753co_sier
costar85518613co_star
costed95623113co_sted
costers94128303co_sters
cotter84926673co_tter
coulter94115593coulter
counter94220143counter
courter94516463courter
couter84930203co_uter
coveter122912063coveter
dabsters1137053dabsters
debater104114693debater
diaster82813313diaster
diester83013683diester
dobber114015413dob_ber
doomster1135843doomster
dopester1137253dopester
dorser74819173dors_er
doser66228563do_s_er
dosser74417973do_sser
dossier83711693dossier
doter65428623do__ter
dotter74419343do_tter
doubter10298353doubter
douser75621633dous_er
dowser104716083dows_er
duster74919723_duster
easter65027983_easter
ester54727713__ester
faster94625773_faster
feaster10812983feaster
fester94723513_fester
fibsters13126403fibsters
floater104413353flo_ater
flosser10339693flo_sser
flossier11326973flossier
flouter104311343flo_uter
fluster103913063fluster
foisted113210603foisted
footer94320763fo_oter
forester11313673forester
fosters104220093fo_sters
fubsier12367763fubsier
gagster9317633gagster
gaster75027353_gaster
glister84013343glister
gloater83711013glo_ater
globate1057823globate_
globated1265753globated
globbier1334243globbier
glosser83410813glo_sser
glossier9358203glossier
gobbler123310023gobbler
goiter74116203go_iter
goosier83512563goosier
gorsier83811073gorsier
grister83915413grister
gypster1333953gypster
hamster12810423hamster
heister103613623heister
hipster12288783hipster
hobber134114633hob_ber
hobbler143710403hobbler
hoisted113411293hoisted
hoisters113513473hoisters
holsters113211933holsters
honester1139713honester
hoopster1335543hoopster
hooter94123923ho_oter
horsier103013243horsier
horste94817413horste_
horstes104516113horstes
hoser811529763ho_s_er
hosier94219613ho_sier
hosted105020343ho_sted
hostel93914153ho_stel
hostler103411023ho_stler
hotter94720073ho_tter
houser95322283hous_er
jester134319153_jester
jobber173813353job_ber
jointer14379713jointer
joisted15379173joisted
jokester1934443jokester
jolter133513093jo_lter
josher164312963jo_sher
jostler14288223jo_stler
jotter134315633jo_tter
jousted15339143jousted
jousters153210403jousters
juster134617013_juster
keester11319913keester
keister113011573keister
keyster14256153keyster
kiester11329973kiester
klister113410643klister
kosher134412973ko_sher
labeler92310183labeler
laborer9249503laborer
lamister1037653lamister
lamsters1099753lamsters
lapser84113143laps_er
laser54633323l_as_er
lasher94824533l_asher
lassoer7379383lassoer
lasted74323603l_asted
lasters75627693l_asters
later54843923l__ater
latter65027893l_atter
leaser65322673leas_er
lefter93613433l_efter
leisters83312823leisters
lesser63514853l_esser
letter63722583l_etter
libber104414003lib_ber
libeler9219003libeler
liber74723613lib__er
lifter93814813l_ifter
lighter113113423lighter
limiter92710853limiter
linter64625333l_inter
lisper84114433l_isper
listed74322833l_isted
listee64223063l_istee
listel64214733l_istel
listen64816813l_isten
listers74026523l_isters
liter54736343l__iter
litter64324853l_itter
loader74316303lo_ader
loadstar943363loadstar
loafer93610943lo_afer
loamier9349163loamier
loaner64416503lo_aner
loather103711003loather
lobar7313013lob__ar
lobately1344013lobately
lobbed113114613lob_bed
lobbers113713933lob_bers
lobbied12337173lobbied
lobbies113612463lobbies
lobbyers1533193lobbyers
lobe65535363lob__e_
lobed86022133lob__ed
lobes75331003lob__es
lobs66441083lobs___
lobsterers1243483lobsterers
lobstering1345113lobstering
lobsterman1452313lobsterman
lobstermen1452523lobstermen
lobstick1694013lobstick
lobular936663lobular
lobule82910063lobule_
lobules92510813lobules
locate83919843locate_
located103114183located
locaters102710063locaters
locates93218813locates
locator93110423locator
locker124019423lo_cker
lockstep1643813lockstep
lodestar944413lodestar
lodger86517683lo_dger
loesses7310033loesses
lofted103811893lo_fted
lofters103912903lo_fters
loftier1037763loftier
logger86420003lo_gger
loggier93811143loggier
logier75015733lo_gier
loiters74116613lo_iters
loller63315283lo_ller
loner55431033lo__ner
longer75823193lo_nger
looker104816953lo_oker
loonier73312673loonier
looper83817113lo_oper
loopier93711193loopier
loose56627683loos_e_
loosed75520893loos_ed
loosen66615963loos_en
loosener845633loosener
looses67328243loos_es
looted74421113lo_oted
looters74419163lo_oters
loper75129233lo__per
lopper103717203lo_pper
loppier11369723loppier
lorimer937753lorimer
loriner7511883loriner
lose45144583lo_s_e_
losel54419423lo_s_el
losers65123583lo_s_ers
loses56742013lo_s_es
losses65925233lo_sses
lost47951493lo_st__
lotte54923853lo_tte_
lotted74222403lo_tted
lotters73921063lo_tters
lottery10389823lo_ttery
lottes65322753lo_ttes
louder74414603lo_uder
lounger84610213lounger
louse56131013lous_e_
loused74822913lous_ed
louses66230283lous_es
louted74920693lo_uted
louver94110393lo_uver
lover85526453lo__ver
lower85830413lo__wer
lowlier10338903lowlier
lowse87219903lows_e_
loyaler1035083loyaler
lubber104214623lub_ber
lusher93818763l_usher
lusted74319443l_usted
lusters73921433l_usters
lustier73813503l_ustier
lustre64011683l_ustre
master84831343_master
meister93114163meister
minster93914323minster
mister84728563_mister
mobber123613463mob_ber
modester1197483modester
moisten93110143moisten
molester1099373molester
molter84119423mo_lter
momser104011413moms_er
monstera10318873monstera
monsters103314533monsters
mooter83921093mo_oter
mosher114719793mo_sher
mosser84618273mo_sser
mossier94413813mossier
moste75925083mo_ste_
moulter93812423moulter
mounter93713173mounter
mouser85822443mous_er
mousier93712463mousier
munster93710523munster
muster84724523_muster
nester64124183_nester
nobbier11309163nobbier
nobbler113211183nobbler
nobler83713453nob_ler
noisier759453noisier
nooser65517823noos_er
nosher94616363no_sher
nosier63716323no_sier
noter55025643no__ter
oater55433733_o_ater
obeyer1135893_obeyer
ofter84116873_o_fter
oldsters996733oldsters
oleaster837263oleaster
orbiter937853orbiter
osier53518013_o_sier
ostler63312193_o_stler
otter54423973_o_tter
ousted73720583_ousted
ousters74122773_ousters
outer55633303_o_uter
oxter123414093_o_xter
oysters103411683_oysters
paster85734373_paster
penster92811953penster
pester84827593_pester
piaster93012883piaster
plaister1068013plaister
plaster93318693plaster
plotter94113663plo_tter
pointer93814933pointer
poiser84217243pois_er
politer92417073politer
pollster1037103pollster
poofter1237163poofter
porter84224413po_rter
poser75128773po_s_er
posher115018163po_sher
posted93722493po_sted
postern93615603po_stern
posters93927993po_sters
potter83926983po_tter
poulter93712013poulter
pouter83923983po_uter
powter114116033po_wter
prester93519623prester
punster92911103punster
quester161410023quester
raster64731443_raster
rebater93517903rebater
rester63832433_rester
roadster935453roadster
roasted83912663roasted
roasters83615913roasters
robber103916533rob_ber
roisters83615543roisters
rooser63921883roos_er
roosted83211883roosted
roosters83514653roosters
rooter64926033ro_oter
rosier64221263ro_sier
rosters73727533ro_sters
rotter64325463ro_tter
rouser65224083rous_er
rousted84013323rousted
rousters84315653rousters
router65025843ro_uter
roysters113610523roysters
shyster13116553shyster
sister64421583_sister
slobber11388903slob_ber
slobbier1254633slobbier
slotter73314443slo_tter
sobber104016583sob_ber
sober74822403sob__er
soberer93110353soberer
sodbuster1242603sodbuster
softer94015313so_fter
songster935783songster
sonsier7711743sonsier
sorter64425083so_rter
souter64225923so_uter
tapster9299273tapster
taster64930573_taster
tester64227153_tester
tipster9299053tipster
toasted84011923toasted
toasters83912703toasters
toastier846893toastier
tooter64420803to_oter
tosser64215663to_sser
toter55932133to__ter
totter65021463to_tter
touter63821033to_uter
truster73114313truster
tryster10369513tryster
twister10308953twister
ulster63712103_ulster
vaster94521023_vaster
vomiter1237953vomiter
voter85121053vo__ter
waister103812383waister
waster95228943_waster
websters1335803websters
wester94222893_wester
wobbler14329823wobbler
worser95117523wors_er
worsted1138013worsted
wowser125110203wows_er
wrester102812413wrester
xyster16366803_xyster
yester93417983_yester
zester153617793_zester
zosters163015403zo_sters

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274578.12616493.6
3Display Results4574570.1702688.2
 (SQL Overall)1786914578.45221141.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.