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

366 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
mobsters1235906(None) 
lobsters10268741lobsters
mobster11299211mobster_
monsters103314551monsters
boasters103915662boasters
bolsters103712452bolsters
boosters104013452boosters
coasters104317342coasters
costers94128342co_sters
dabsters1137052dabsters
fibsters13126412fibsters
fosters104220102fo_sters
hoisters113513492hoisters
holsters113211942holsters
jousters153210422jousters
lobster9288852lobster_
masters94628922m_asters
meisters103313842meisters
minsters103813922minsters
misters93927512m_isters
mobbers133610922mob_bers
moistens10268772moistens
moister94015372moister_
molesters1198872molesters
molters93816972mo_lters
momsers113810852moms_ers
monster93214602monster_
monstera10318882monstera
monsteras11318242monsteras
mooters93818622mo_oters
moshers124017842mo_shers
mossers94116192mo_ssers
moulters103510782moulters
mounters103712502mounters
mousers95216442mous_ers
munsters104010552munsters
musters94522512m_usters
ousters74122792_ousters
oysters103411692_oysters
posters93928012po_sters
roasters83615932roasters
roisters83615562roisters
roosters83514672roosters
rosters73727552ro_sters
rousters84315682rousters
roysters113610532roysters
toasters83912722toasters
websters1335802websters
zosters163015412zo_sters
abaters95115203_abaters
aborters1038573aborters
arbiters1038853arbiters
asters65631603__asters
basters94930313_basters
bisters93922613_bisters
biters83925243__biters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boaster94616433boaster_
boaters93419243bo_aters
bobbers103614283bob_bers
bobsleds13304383bobsleds
bobstays1543343bobstays
bolster93713423bolster_
bolters94017803bo_lters
bombasters1643713bombasters
booster94314553booster_
bursters1038983bursters
busters94724133_busters
casters94729903_casters
cloisters1137443cloisters
clusters102912403clusters
clysters13227843clysters
coaster94219043coaster_
coaters93525793co_aters
cobbers134114753cob_bers
cobblers14359593cobblers
cointers103616423cointers
colters93522443co_lters
combaters1538113combaters
cooters94525733co_oters
copters113621283co_pters
coshers123618183co_shers
costars94218013co_stars
coster84331293co_ster_
cotters94323453co_tters
coulters103614313coulters
counters103320193counters
courters103015373courters
couters93827303co_uters
coveters132411083coveters
dabster1036703dabster_
debaters113511923debaters
diasters92913183diasters
diesters92513603diesters
dobbers123513253dob_bers
doomsters1236173doomsters
dopesters1237283dopesters
dorsers83516303dors_ers
dosers75723633do_s_ers
dossers84516233do_ssers
dossiers9318043dossiers
doters74423913do__ters
dotters83715973do_tters
doubters11257393doubters
dousers84817273dous_ers
dowsers115013533dows_ers
dusters84918363_dusters
easters75125683_easters
embossers1343413embossers
emoters94712873emo__ters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibster12146533fibster_
flusters113811503flusters
footers104618333fo_oters
foresters12312543foresters
foster94322223fo_ster_
gagsters10317083gagsters
gasters85624303_gasters
glisters93912603glisters
gobblers13308343gobblers
goiters84014443go_iters
gristers94013413gristers
gypsters1434023gypsters
hamsters13710423hamsters
heisters113413133heisters
hipsters13268793hipsters
hobbers143512343hob_bers
hobblers15308513hobblers
hoister103714203hoister_
holster103512213holster_
hoopsters1445693hoopsters
hooters104520483ho_oters
horstes104516113horste_s
hosers95223973ho_s_ers
hosiers104212643ho_siers
hostels103712323ho_stels
hostess103210243ho_stess
hostlers113310483ho_stlers
housers104717823hous_ers
imposters13347343imposters
jesters144118193_jesters
jobbers182911133job_bers
jointers15289323jointers
jokesters2044443jokesters
jolters143711993jo_lters
joshers174111593jo_shers
jostlers15357683jo_stlers
jotters143413803jo_tters
jouster143311043jouster_
justers143815733_justers
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310153kiesters
klisters123910483klisters
koshers144811803ko_shers
lamsters1099753lamsters
lasters75627693_lasters
leisters83312823leisters
listers74026533_listers
lobbers113713943lob_bers
lobbyers1533193lobbyers
lobstered1244643lobstered
lobsterer1144033lobsterer
lobsterers1243483lobsterers
locaters102710073locaters
lofters103912903lo_fters
loiters74116613lo_iters
looters74419163lo_oters
losers65123583lo_s_ers
lotters73921063lo_tters
lusters73921443_lusters
magisters1235803magisters
maltsters1135193maltsters
masers84623453m_as_ers
mashers124621053m_ashers
maskers133913843m_askers
masseters1136293masseters
master84831343m_aster_
mastery124214323m_astery
maters85032393m__aters
matters94421753m_atters
meeters94714543m_eeters
meister93114163meister_
melters93918313m_elters
mestees94617753m_estees
meters85625833m__eters
milters93619093m_ilters
ministers1139623ministers
minster93914323minster_
minters93822473m_inters
misers85025703m_is_ers
missteers1135913missteers
missteps12156143missteps
mister84728563m_ister_
misterm114314513m_isterm
misterms123711353m_isterms
miters84328783m__iters
moaners92813553mo_aners
mobber123613463mob_ber_
mobiles112813123mobile_s
mockers153812943mo_ckers
modelers1138463modelers
modester1197483modester_
modistes1138643modiste_s
moilers93615203mo_ilers
moisten93110143moiste_n
moisteners1244783moisteners
moistest1038763moistest
moistness1146343moistness
moisture1046653moisture
moistures1147323moistures
molders103315553mo_lders
molester1099373molester_
molter84119423mo_lter_
momser104011413moms_er_
momzers20367133mo_mzers
monastery1444373monastery
moneyers1337423moneyers
mongers104217273mo_ngers
monikers1437413monikers
monitors10310823monitors
monoesters1245993monoesters
monomers12311033monomers
montero9310133mo_ntero
monteros1039453mo_nteros
montes84226933mo_nte_s
moochers15369123moochers
mooners94015343mo_oners
mooter83921093mo_oter_
mopers104220373mo__pers
moppers133412463mo_ppers
morsels94112663mors_els
mortars93411523mo_rtars
moseys114711713mo_s_eys
mosher114719793mo_sher_
moshes115222873mo_she_s
mosser84618273mo_sser_
mosses85527683mo_sse_s
mossier94413813mossier_
moste75925083mo_ste__
mostest9314793mo_stest
mostests1036833mo_stests
mosts76028543mo_st__s
motels83616903mo__tels
motes75944003mo__te_s
motets84216193mo__tets
mothers123717623mo_thers
motors84616603mo__tors
mottes85523693mo_tte_s
mottlers10388183mottlers
moulders11348343moulders
moulter93812423moulter_
mounter93713173mounter_
mourners1036913mourners
mouser85822443mous_er_
mouses85531423mous_e_s
mousier93712463mousier_
mousses94012703mousse_s
mouthers133811303mouthers
movers115117193mo__vers
mowers113219403mo__wers
muensters1143253muensters
munster93710523munster_
musers84719103m_us_ers
mushers124016443m_ushers
mustees94614923m_ustees
muster84724523m_uster_
mutters94117143m_utters
mystery15436523m_ystery
nesters74422793_nesters
nobblers12318563nobblers
noosers74913933noos_ers
noshers103614333no_shers
noters64021003no__ters
oaters65029793_o_aters
obeyers1234813_obeyers
obsess845943_obs_ess
oldsters996733oldsters
ombers104214403omb__ers
omitters10277653omitters
orbiters1036603orbiters
osiers63412793_o_siers
ostlers72911203_o_stlers
otters64021513_o_tters
ouster64223733_ouster_
outers64230173_o_uters
oxters134813273_o_xters
oyster94111703_oyster_
pasters94531733_pasters
pensters103012123pensters
pesters93827093_pesters
piasters102912813piasters
plasters103518133plasters
pointers103013723pointers
poisers94214433pois_ers
pollsters1137173pollsters
poofters1336923poofters
porters93722703po_rters
posers84223973po_s_ers
poster84129173po_ster_
postern93615613po_stern
posterns102713723po_sterns
potters94024343po_tters
poulters103911053poulters
pouters94221873po_uters
powters124015663po_wters
presters103419003presters
punsters103310583punsters
questers17168773questers
rasters74629023_rasters
rebaters103413943rebaters
resters74130403_resters
roadsters1035103roadsters
roaster74116663roaster_
robbers112814163rob_bers
robuster1035663robuster_
roister73516203roister_
roosers74217883roos_ers
rooster74415173rooster_
rooters74522933ro_oters
roster64329083ro_ster_
rotters74421393ro_tters
rousers75220143rous_ers
rouster73517083rouster_
routers74822873ro_uters
royster103110533royster_
shysters14106463shysters
sisters73721593_sisters
sobbers114114263sob_bers
sobers85218863sob__ers
sodbusters1342593sodbusters
songsters1046113songsters
sorters74221133so_rters
souters74422603so_uters
tapsters10318803tapsters
tasters74225643_tasters
testers74124543_testers
tipsters10278523tipsters
toaster74414463toaster_
tooters73818773to_oters
tossers74713503to_ssers
toters65026363to__ters
totters74618733to_tters
touters74018353to_uters
trusters83112263trusters
trysters11298373trysters
twisters11268173twisters
ulsters72711983_ulsters
vomiters1337203vomiters
voters95017443vo__ters
waisters113811523waisters
wasters104026593_wasters
webster1236093webster_
westers105221963_westers
wobblers15327883wobblers
worsteds1234493worsteds
wowsers13488763wows_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.423422437.4
2DLD Change Limit1461623667.34319904.9
3Display Results3663660.1402614.3
 (SQL Overall)1786913667.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.