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

157 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
modester119748(None) 
molester1099371molester
dopester1137252dopester
forester11313672forester
honester1139712honester
jokester1934442jokester
lodestar944412lodestar
mobster11299212mo_bster
modeler1039292mode_ler
modeller1136612modeller
moderner1145522moderner
modest93818452modest__
modestest1245002modestest
modesties1247472modesties
modestly14375582modestly
modesty13476982modest_y
modiste1039282modiste_
modistes1138642modistes
moister94015372mo_ister
molested11178242molested
molesters1198872molesters
monoester1146452monoester
monster93214592mo_nster
adepter1036113_adepter
arrester839253arrester
attester836503attester
bimester1236163bimester
boaster94616433bo_aster
bolster93713423bo_lster
booster94314553bo_oster
cadaster1136893cadaster
coaster94219033co_aster
codebtor1343963codebtor
contester11311183contester
coster84331293co__ster
coveter122912063cove_ter
defter104215923__defter
deter65028043__de_ter
detester9239683detester
dexter143810893__dexter
diester83013683_diester
digester10258423digester
doomster1135843doomster
dopesters1237283dopesters
duster74919723__duster
ester54727713___ester
fester94723513__fester
fomenter1339263fomenter
foreseer1139013foreseer
forested12312463forested
foresters12312533foresters
foster94322223fo__ster
gamester1137323gamester
hoister103714203ho_ister
holster103512213ho_lster
hoopster1335543hoopster
indenter92311443indenter
infester11239433infester
jester134319153__jester
jokesters2044443jokesters
jouster143311043jo_uster
keester11319913_keester
kiester11329973_kiester
lobster9288853lo_bster
lodestars1044413lodestars
magister1136283magister
maltster1035303maltster
masseter1037063masseter
master84831343m__aster
meeter83616503m__eeter
meister93114163m_eister
melter83520113m__elter
mestee84523883m__estee
meter75130323m__e_ter
minister10410363minister
minster93914323m_inster
misenter10310833misenter
mister84728563m__ister
mobsters12359053mo_bsters
modeled1139453mode_led
modelers1138463mode_lers
modelled1236423modelled
modellers1245393modellers
modemed1336723mode_med
moderate11710993moderate_
moderated1388143moderated
moderates12710743moderates
moderator12106543moderator
moderne1037123moderne_
modernes1138423modernes
modes85537413modes___
modifier1446693modifier
mofette1296773mofette_
mofettes1386083mofettes
moisten93110143mo_isten
molest85022743molest__
molests93311563molest_s
molter84119423mo__lter
momser104011413mo_ms_er
monastery1444373monastery
moneyer1237903mone_yer
monoesters1245983monoesters
monstera10318873mo_nstera
monsters103314533mo_nsters
mooter83921093mo__oter
moreover1344863moreover
mosher114719793mo__sher
mosser84618273mo__sser
mossier94413813mo_ssier
moste75925083mo__ste_
moulter93812423mo_ulter
mounter93713173mo_unter
mouser85822443mo_us_er
mousier93712463mo_usier
mozette1886773mozette_
muenster1043313muenster
munster93710523m_unster
muster84724523m__uster
nester64124183__nester
oldster896573_oldster
oleaster837263_oleaster
ouster64223733_o_uster
oyster94111703_o_yster
pester84827593__pester
podesta1036763podest_a
podestas1146853podestas
polestar1047113polestar
pollster1037103pollster
polyester1445353polyester
poster84129173po__ster
prester93519623_prester
protester111510483protester
quester161410023_quester
rester63832433__rester
rimester1037813rimester
roadster935453roadster
roaster74116663ro_aster
robuster1035663robuster
roister73516203ro_ister
rooster74415173ro_oster
roster64329083ro__ster
rouster73517083ro_uster
royster103110533ro_yster
semester1038903semester
sidestep1144243sidestep
sodbuster1242603sodbuster
songster935783songster
tester64227153__tester
toadeater1044823toadeater
toaster74414463to_aster
wester94222893__wester
wrester102812413_wrester
yester93417983__yester
yodeler1136343yode_ler
yodeller1244853yodeller
zester153617793__zester
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.1531167915.0
2DLD Change Limit1461621577.72018932.9
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.93622516.5
 
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.