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

499 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
messier9341292(None) 
massier93615221massier
meshier123410851meshier
mossier94413811mossier
mussier93314351mussier
bossier93712422bossier
dossier83711692dossier
dressier956862dressier
easier64218462_easier
fussier103610672fussier
gassier83812572gassier
hissier103410502hissier
lesser63514852less_er
mealier93015902mealier
measlier1036012measlier
meatier93214612meatier
meister93114162meister
merrier92612302merrier
messed95018182mess_ed
messes84924342mess_es
messiah1246792messiah
messiest103112422messiest
messieurs1142112messieurs
messily12298812messily
messing103916392messing
messmen1137392messmen
metier83517692me_tier
missies93423982missies
mistier93418712mistier
mosser84618272moss_er
mousier93712462mousier
mushier123813582mushier
muskier134312722muskier
mustier94017952mustier
newsier10147222newsier
peskier13319112peskier
pestier94317402pestier
pussier93711992pussier
sassier73413232sassier
sissier73711362sissier
testier74015642testier
tressier847962tressier
wussier10408082wussier
zestier163010222zestier
aerier64823153ae_rier
amasser9418733amass_er
antsier7410773antsier
artsier768943artsier
ashier94714833_ashier
beadier103513913beadier
beakier134012163beakier
beamier113411943beamier
beefier12329093beefier
beerier93613023beerier
belier84423563be_lier
bendier103111413bendier
beshiver1634483beshiver
bestir8311163besti_r
bitsier9379073bitsier
blesser9329293bless_er
boskier13309173boskier
bossies94116833bossies
brasier94516753brasier
brassier103310533brassier
bushier123712813bushier
busier85219723_busier
bustier93916153bustier
cashier123713323cashier
censer84516583cens_er
cessed94615613cess_ed
cesses84221363cess_es
cessing103814813cessing
cession939813cession
cheesier1335963cheesier
chestier1387423chestier
cissies94116153cissies
classier10359083classier
cosier84423753_cosier
creasier103210193creasier
crosier94116573crosier
cushier123610833cushier
cusser86016093cuss_er
dashier114311183dashier
dassie74615573dassie_
dassies84418663dassies
decrier102713553decrier
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
denier74420693de_nier
denser74115193dens_er
dernier83011943dernier
descrier1157623descrier
desire7415303de_sire
desirer8310783desirer
despiser1136343despiser
dessert82916453dess_ert
destrier9311823destrier
deviser114212393deviser
dewier104013463de_wier
dishier113613403dishier
ditsier83010293ditsier
dosser74417973doss_er
dossiers9318043dossiers
dresser83611953dress_er
drossier956313drossier
duskier12409423duskier
dustier83814133dustier
easies64126633_easies
easter65027983_easter
edgier8469723_edgier
eelier64216463_eelier
eerier64320023_eerier
elmier839813_elmier
emptier1187603emptier
envier939673_envier
esker94412983_e_sker
espied9359773_espied
espies83716803_espies
essayer1033943_essayer
esses56422973_ess_es
ester54727713_e_ster
feaster10812983feaster
feistier1136193feistier
fennier10339253fennier
fernier103110813fernier
fesse86116333fess_e_
fessed104515063fess_ed
fesses94820253fess_es
fessing113812863fessing
fester94723513fe_ster
fishier13359853fishier
fleshier1435603fleshier
flossier11326973flossier
fubsier12367763fubsier
fusser94813773fuss_er
fustier104213933fustier
gasser75017773gass_er
geekier12286393geekier
gemmier12337383gemmier
germier10309543germier
gessoed935743gessoed
gessoes838293gessoes
geyser1036513geys_er
glassier9289083glassier
glossier9358203glossier
goosier83512563goosier
gorsier83811073gorsier
gossiper1164203gossiper
grassier9349283grassier
greasier9298083greasier
guesser8166543guess_er
gushier113110073gushier
gussie72910153gussie_
gussied9267193gussied
gussies82813303gussies
gustier83813863gustier
gutsier8389823gutsier
hastier103916623hastier
headier113212953headier
heavier13429423heavier
hedgier12367873hedgier
heftier1337203heftier
heister103613623heister
hempier14319003hempier
herbier1239593herbier
hessian1035853hessian
hessite1038993hessite
hessites1138613hessites
hisser94713793hiss_er
hissies103915823hissies
horsier103013243horsier
hosier94219613_hosier
huskier14369753huskier
hussies103213293hussies
issuer646623_issuer
jerkier18407273jerkier
jesse126012833jess_e_
jessed144112303jess_ed
jesses135215953jess_es
jessing153710623jessing
jester134319153je_ster
jettier14358693jettier
keester11319913keester
keister113011573keister
keyster14256153keyster
kisser104212453kiss_er
lassie64917743lassie_
lassies74420103lassies
lassoer7379383lassoer
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
learier73415663learier
leaser65322673leas_er
leavier10319993leavier
ledgier9458493ledgier
leerier73111503leerier
leggier9368233leggier
leister73212753leister
lessee64116363less_ee
lessees73510243lessees
lessen64212433less_en
lessor64010603less_or
levier94013873le_vier
lousier72411623lousier
lustier73813503lustier
malmier113611953malmier
maltier93015483maltier
mangier104114063mangier
manlier92414023manlier
marlier92614773marlier
marrier93817523marrier
marshier1337593marshier
maser75029973m_as_er
masher114123203m_asher
mashie11315933mashie_
mashies12318253mashies
masker124416103m_asker
masquer18266463masquer
massager1136873massager
masse75125293mass_e_
massed94421323mass_ed
masses85028713mass_es
masseter1037063masseter
masseur935703masseur
massiest103314423massiest
massif11412533massi_f
massifs1237743massifs
massing104318023massing
massive12289773massive
master84831343m_aster
matier84321523m_atier
mazier175013063m_azier
meager94515193me_ager
mealie82519803mealie_
mealies92821933mealies
meander1049973meander
meaner84617843me_aner
meanie83718393meanie_
meanies93620743meanies
measle83513223measle_
measled10339303measled
measles92412753measles
measure939033measure
measurer1035953measurer
meddler11319953meddler
meeker12359983me_eker
meeter83616503me_eter
meinie82614523meinie_
meinies92516073meinies
meisters103313843meisters
melder93915813me_lder
melter83520113me_lter
member12258853me_mber
memoir1037213memoi_r
menacer112610883menacer
mender93520793me_nder
menhir1136783menhi_r
mensae84114043mensae_
mense75025633mens_e_
mensed93916543mens_ed
menses84222453mens_es
menshen1236803menshen
menshes12310443menshes
mensing103915103mensing
menswear1352173menswear
mercer105214203me_rcer
mercies113817563mercies
merer75126233me__rer
merger95016473me_rger
merises93421423merises
meshed124415933me_shed
meshes115019443me_shes
meshiest132911033meshiest
meshing134513813meshing
mesial84818083me_sial
mesian84315503me_sian
mesic93617863me_si_c
mesne75116293me_sne_
mesnes85216213me_snes
mesoderm1344493mesoderm
mesomere1247193mesomere
mess65932433mess___
message1037833message
messaged1235543messaged
messages1138233messages
messan83912063mess_an
messans92710463messans
messenger1243303messenger
messiahs1343963messiahs
messiness11248223messiness
messman1137283messman
messy104913833mess__y
mestee84523883me_stee
mestees94617753mestees
mestino9411643mestino
mestiza1835383mestiza
mestizo1845943mestizo
metamer1139613metamer
meter75130323me__ter
metiers93312843me_tiers
meuniere1043233meuniere
mewler113510233me_wler
miffier1537023miffier
milkier133411163milkier
millier93716703millier
miltier93214963miltier
mincier113512463mincier
mingier103815293mingier
minster93914323minster
mintier93615993mintier
mirier83918363m_irier
mirkier13319053mirkier
misaver1249813misaver
misdoer1048633misdoer
miser75430403m_is_er
misfire12229893misfire
mislie83219153mislie_
mislies92922283mislies
misliker14319573misliker
missed94423603miss_ed
missel85216523miss_el
misses85130873miss_es
misset85028153miss_et
missile92815403missile
missileer1145583missileer
missilery1444553missilery
missiles103015083missiles
missilry1344653missilry
missing103619073missing
mission9312743mission
missioner1147883missioner
missis84417503missi_s
missises103513693missises
missive122413143missive
missives133212843missives
missteer1037223missteer
misstep11158463misstep
mister84728563m_ister
misuser93210443misuser
mitier83620673m_itier
mobster11299213mobster
moister94015373moister
moldier103110033moldier
momser104011413moms_er
monsieur1043313monsieur
monster93214593monster
moodier103212203moodier
moonier93714103moonier
moorier93113073moorier
mopier103914783m_opier
mosher114719793m_osher
mossed94818893moss_ed
mossers94116193moss_ers
mosses85527683moss_es
mossiest103112443mossiest
mossing103915423mossing
mothier121910213mothier
motlier92010583motlier
mouser85822443mous_er
muckier153411473muckier
muddier114110013muddier
muenster1043313muenster
muggier11288943muggier
munster93710523munster
murkier133110263murkier
muser76024123m_us_er
musher113820573m_usher
muskie123412533muskie_
muskies133614663muskies
mussed94418903muss_ed
mussel83412903muss_el
musses84624783muss_es
mussiest103112933mussiest
mussily12279773mussily
mussing104015543mussing
muster84724523m_uster
muzzier17326553muzzier
mythier15125183mythier
nastier74115293nastier
needier84010623needier
nerdier83110353nerdier
nervier10298833nervier
nesses64718323ness_es
nester64124183ne_ster
nestler73510443nestler
nettier74211813nettier
newsie9138213newsie_
newsies101310383newsies
noisier759453noisier
nosier63716323_nosier
nutsier7329253nutsier
osier53518013__osier
passer84721033pass_er
pastier94320383pastier
peakier134411443peakier
peatier94017233peatier
peckier153910523peckier
penster92811953penster
peppier10268323peppier
perkier133813123perkier
pester84827593pe_ster
pettier94213613pettier
pisser84416383piss_er
presser93717623press_er
prissier10157873prissier
prosier93817483prosier
pursier94012753pursier
pushier123611093pushier
pussies93615693pussies
queasier1734473queasier
raspier93110633raspier
readier83117423readier
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
reifier103414523reifier
reissuer854523reissuer
relier65826183re_lier
rentier73618223rentier
replier94214973replier
rescuer939033rescuer
resider84615803resider
resister8311653resister
respire9411543respire
rester63832433re_ster
resumer9410113resumer
reviser104114663reviser
riskier1138423riskier
rosier64221263_rosier
rushier103411973rushier
rustier74416363rustier
sassies74719263sassies
seamier93114633seamier
sedgier9399043sedgier
seedier83513633seedier
seepier92912013seepier
seiser65318343seis_er
sessile739523sessile
session739743session
sexier13310683se_xier
shier85428943__shier
sissies73716603sissies
skier95119593__skier
slier54827243__slier
smearier1036953smearier
smellier1036793smellier
sonsier7711743sonsier
spier75728033__spier
sudsier868773sudsier
tarsier74119253tarsier
tassie66017023tassie_
tassies74918933tassies
tastier711817093tastier
tearier73815613tearier
teaser65421523teas_er
techier1269243techier
teenier72611143teenier
teensier835573teensier
tenser64919433tens_er
tentier73815923tentier
terrier73414963terrier
terser67317823ters_er
tessera736333tess_era
tester64227153te_ster
tipsier9268893tipsier
tosser64215663toss_er
tusser64615833tuss_er
uneasier836963uneasier
vastier103613203vastier
vealier102712173vealier
veinier10269583veinier
verier94620963ve_rier
vernier102711273vernier
verser94516963vers_er
vesper1138083ve_sper
vessel937953vess_el
washier133611153washier
waspier12259053waspier
wearier103613283wearier
webbier1445423webbier
webster1236093webster
wedgier12428273wedgier
weedier113810623weedier
weenier103210803weenier
weensier1134243weensier
weepier12319273weepier
welsher13377443welsher
wennier10318603wennier
wester94222893we_ster
wispier12249403wispier
wussies103411083wussies
yeastier1135393yeastier
yessed104511163yess_ed
yesses93615813yess_es
yessing113210063yessing
yester93417983ye_ster
zester153617793ze_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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274997.20318607.1
3Display Results4994990.1862682.8
 (SQL Overall)1786914997.54523683.4
 
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.