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

369 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
lobsters1026873(None) 
lobster9288851lobster_
mobsters12359051mobsters
boasters103915652boasters
bolsters103712442bolsters
boosters104013432boosters
cloisters1137412cloisters
coasters104317302coasters
costers94128302co_sters
dabsters1137052dabsters
fibsters13126402fibsters
fosters104220092fo_sters
hoisters113513472hoisters
holsters113211932holsters
jousters153210402jousters
lamsters1099752lamsters
lasters75627692l_asters
leisters83312822leisters
listers74026522l_isters
lobbers113713932lob_bers
lobbyers1533192lobbyers
lobstered1244632lobstered
lobsterer1144032lobsterer
lobsterers1243482lobsterers
locaters102710062locaters
lofters103912902lo_fters
loiters74116612lo_iters
looters74419162lo_oters
losers65123582lo_s_ers
lotters73921062lo_tters
lusters73921432l_usters
mobster11299212mobster_
monsters103314532monsters
oldsters996732oldsters
ousters74122772_ousters
oysters103411682_oysters
posters93927992po_sters
roasters83615912roasters
roisters83615542roisters
roosters83514652roosters
rosters73727532ro_sters
rousters84315652rousters
roysters113610522roysters
toasters83912702toasters
websters1335802websters
zosters163015402zo_sters
abaters95115193_abaters
aborters1038563aborters
alabasters1243253alabasters
arbiters1038853arbiters
asters65631603__asters
basters94930303_basters
bisters93922603_bisters
biters83925233__biters
blasters104116143blasters
blisters104015083blisters
bloaters103311013blo_aters
blotters104110983blo_tters
blusters104413883blusters
boaster94616433boaster_
boaters93419233bo_aters
bobbers103614283bob_bers
bobsleds13304383bobsleds
bobstays1543343bobstays
bolster93713423bolster_
bolters94017803bo_lters
bombasters1643693bombasters
booster94314553booster_
bursters1038983bursters
busters94724123_busters
casters94729893_casters
clobbers14397513clob_bers
cloister1037093cloister_
closers94415313clo_s_ers
clouters10399793clo_uters
clusters102912393clusters
clysters13227823clysters
coaster94219033coaster_
coaters93525773co_aters
cobbers134114753cob_bers
cobblers14359593cobblers
cointers103616403cointers
colters93522433co_lters
combaters1538093combaters
cooters94525713co_oters
copters113621273co_pters
coshers123618173co_shers
costars94217993co_stars
coster84331293co_ster_
cotters94323433co_tters
coulters103614303coulters
counters103320183counters
courters103015363courters
couters93827283co_uters
coveters132411073coveters
dabster1036703dabster_
debaters113511913debaters
diasters92913173diasters
diesters92513593diesters
dobbers123513243dob_bers
doomsters1236163doomsters
dopesters1237283dopesters
dorsers83516293dors_ers
dosers75723633do_s_ers
dossers84516233do_ssers
dossiers9318043dossiers
doters74423913do__ters
dotters83715973do_tters
doubters11257373doubters
dousers84817273dous_ers
dowsers115013523dows_ers
dusters84918353_dusters
easters75125683_easters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibster12146533fibster_
floaters112711503flo_aters
flossers11307863flo_ssers
flouters11419263flo_uters
flusters113811493flusters
footers104618333fo_oters
foresters12312533foresters
foster94322223fo_ster_
gagsters10317073gagsters
gasters85624283_gasters
glisters93912603glisters
gloaters9288853glo_aters
glossers9319053glo_ssers
gobblers13308343gobblers
goiters84014433go_iters
gristers94013403gristers
gypsters1434023gypsters
hamsters13710423hamsters
heisters113413133heisters
hipsters13268783hipsters
hobbers143512343hob_bers
hobblers15308513hobblers
hoister103714203hoister_
holster103512213holster_
hoopsters1445673hoopsters
hooters104520463ho_oters
horstes104516113horste_s
hosers95223953ho_s_ers
hosiers104212633ho_siers
hostels103712313ho_stels
hostess103210233ho_stess
hostlers113310483ho_stlers
housers104717813hous_ers
jesters144118193_jesters
jobbers182911133job_bers
jointers15289323jointers
jokesters2044443jokesters
jolters143711993jo_lters
joshers174111593jo_shers
jostlers15357683jo_stlers
jotters143413803jo_tters
jouster143311043jouster_
justers143815723_justers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310143kiesters
klisters123910483klisters
koshers144811803ko_shers
labelers10249413labelers
laborers10208383laborers
lamisters1157123lamisters
lamster9109913lamster_
lapsers93911053laps_ers
lasers64925703l_as_ers
lashers104121833l_ashers
lassoers8338513lassoers
laster64830633l_aster_
leasers74717843leas_ers
leister73212753leister_
letters73819853l_etters
libbers113812823lib_bers
libelers10238623libelers
libers84721433lib__ers
lifters104313773l_ifters
lighters123111373lighters
limiters10249323limiters
linters73822613l_inters
lispers94514323l_ispers
listees73416673l_istees
listels74212433l_istels
listens74014133l_istens
lister64527253l_ister_
liters65429873l__iters
litters73422563l_itters
loaders83413413lo_aders
loadstars1043303loadstars
loafers10349463lo_afers
loaners73913623lo_aners
loathers113310433loathers
lobate82915243lobate__
lobated102610943lobate_d
lobately1344013lobately
lobber104016593lob_ber_
lobbies113612463lobbie_s
lobbyer1433913lobbyer_
lobes75331003lob__e_s
lobstering1345113lobstering
lobsterings1442883lobsterings
lobsterman1452313lobsterman
lobstermen1452523lobstermen
lobstick1694013lobstick
lobsticks1773553lobsticks
lobules92510813lobule_s
locater93113603locater_
locates93218813locate_s
locators102910413locators
lockers133516923lo_ckers
locksteps1743343locksteps
lodestars1044413lodestars
lodgers95113833lo_dgers
loesses7310033loesse_s
lofter94614723lo_fter_
loggers94616133lo_ggers
loiter64619173lo_iter_
lollers72713793lo_llers
loners64225803lo__ners
longers84819533lo_ngers
lookers114014073lo_okers
loopers93914033lo_opers
looseners945403looseners
loosens716310953loos_ens
looser65219943loos_er_
looses67328243loos_e_s
looter64222323lo_oter_
lopers84424143lo__pers
loppers113014103lo_ppers
lorimers1036613lorimers
loriners839963loriners
losels64714583lo_s_els
loser54728673lo_s_er_
loses56742013lo_s_e_s
losses65925233lo_sse_s
lossless835473lossless
lostness837683lo_stness
lotter64025603lo_tter_
lottery10389823lo_ttery
lottes65322753lo_tte_s
loungers9449003loungers
louses66230283lous_e_s
lousier72411623lousier_
louvers10359103lo_uvers
lovers94223433lo__vers
lowers94624923lo__wers
lubbers113913723lub_bers
luster64023673l_uster_
lustres73013233l_ustres
masters94628923_masters
meisters103313843meisters
minsters103813913minsters
misters93927503_misters
mobbers133610923mob_bers
moistens10268773moistens
moister94015373moister_
molesters1198873molesters
molters93816973mo_lters
momsers113810843moms_ers
monster93214593monster_
monstera10318873monstera
monsteras11318213monsteras
mooters93818623mo_oters
moshers124017843mo_shers
mossers94116193mo_ssers
moulters103510773moulters
mounters103712493mounters
mousers95216443mous_ers
munsters104010543munsters
musters94522493_musters
nesters74422783_nesters
nobblers12318563nobblers
noosers74913903noos_ers
noshers103614323no_shers
noters64020993no__ters
oaters65029783_o_aters
obeyers1234813_obeyers
obsess845943_obs_ess
oldster896573oldster_
oleasters936733oleasters
orbiters1036593orbiters
osiers63412793_o_siers
ostlers72911203_o_stlers
otters64021513_o_tters
ouster64223733_ouster_
outers64230163_o_uters
oxters134813273_o_xters
oyster94111703_oyster_
pasters94531733_pasters
pensters103012123pensters
pesters93827093_pesters
piasters102912803piasters
plaisters1137813plaisters
plasters103518133plasters
plotters104011553plo_tters
pointers103013723pointers
poisers94214433pois_ers
pollsters1137173pollsters
poofters1336923poofters
porters93722703po_rters
posers84223973po_s_ers
poster84129173po_ster_
postern93615603po_stern
posterns102713703po_sterns
potters94024343po_tters
poulters103911043poulters
pouters94221863po_uters
powters124015653po_wters
presters103419003presters
punsters103310583punsters
questers17168763questers
rasters74629023_rasters
rebaters103413913rebaters
resters74130403_resters
roadsters1035083roadsters
roaster74116663roaster_
robbers112814153rob_bers
robuster1035663robuster_
roister73516203roister_
roosers74217873roos_ers
rooster74415173rooster_
rooters74522933ro_oters
roster64329083ro_ster_
rotters74421393ro_tters
rousers75220133rous_ers
rouster73517083rouster_
routers74822853ro_uters
royster103110533royster_
shysters14106433shysters
sisters73721573_sisters
slobbers12398523slob_bers
slotters84012393slo_tters
sobbers114114253sob_bers
sobers85218853sob__ers
sodbusters1342593sodbusters
songsters1046093songsters
sorters74221113so_rters
souters74422583so_uters
tapsters10318803tapsters
tasters74225643_tasters
testers74124543_testers
tipsters10278503tipsters
toaster74414463toaster_
tooters73818773to_oters
tossers74713493to_ssers
toters65026363to__ters
totters74618733to_tters
touters74018333to_uters
trusters83112243trusters
trysters11298363trysters
twisters11268173twisters
ulsters72711983_ulsters
vomiters1337203vomiters
voters95017443vo__ters
waisters113811523waisters
wasters104026593_wasters
webster1236093webster_
westers105221963_westers
wobblers15327883wobblers
worsteds1234483worsteds
wowsers13488753wows_ers
wresters112711733wresters
xysters17307163_xysters
zesters163517293_zesters
zoster153715853zo_ster_

Search took 8 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 Limit1461623697.37619815.9
3Display Results3693690.1402635.7
 (SQL Overall)1786913697.67223291.3
 
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.