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

412 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
moiety114822(None) 
gaiety10119372gaiety
impiety1445082impiety
milty104720072m_ilty
minty106323902m_inty
misty106120452m_isty
mity95528202m_i_ty
modesty13476982modesty
moist76033572moist_
moistly1236612moistly
money104826842mone_y
mopery135210972mopery
mopey124821822mope_y
mosey105922872mose_y
motet75641192motet_
motets84216192motets
motey105922952mote_y
piety105817302_piety
pointy114913282pointy
society1236082society
ubiety1135912ubiety
amity10416083ami_ty
anxiety1744033anxiety
bitty106119173_bitty
bogey115220233boge_y
boite74426323boi_te
boites84322703boites
bolete8519613bolete
boleti8413403boleti
boney105227313bone_y
booty106125913bo_oty
borty105522833bo_rty
bounty113411073bounty
bowery146012113bowery
briery114510773briery
chitty14329433chitty
city95122623_ci_ty
comedy14378233comedy
comely134213733comely
comet95946073comet_
cometh134811683cometh
comets105823583comets
comity13312713comity
coney105932883cone_y
cooey105828223cooe_y
coset75748843coset_
cosets85824403cosets
cosey106226713cose_y
county114313323county
covet105638943covet_
covets114819643covets
covey136121783cove_y
cozey196718543coze_y
dainty105311473dainty
deity94316773dei_ty
dicty115116293_dicty
diet57357533_diet_
diets66026643_diets
dioecy1235543dioecy
dirty95617803_dirty
ditty95019293_ditty
doeth9411983do_eth
dogey105719513doge_y
doily95321033doi_ly
doit56347853doi_t_
doited85016633doited
doits66223673doi_ts
dopey116020353dope_y
dorty96220813do_rty
dotty94516103do_tty
doty86128223do__ty
dowery134311663dowery
drifty13418223drifty
dubiety1344583dubiety
feisty12449293feisty
fiery114714793_fiery
fifty145211423_fifty
flinty126112493flinty
flirty12499143flirty
fogey125617873foge_y
foist85730973foist_
foists95413983foists
foley115222303fole_y
footy115820533fo_oty
foreby1438633foreby
forty114824273fo_rty
gayety13116383gayety
gleety10479193gleety
glinty106910693glinty
godet7530043godet_
godets8410933godets
goiter74116203goiter
gooey95522863gooe_y
gouty95217363go_uty
gritty10338403gritty
guilty10418233guilty
hoist86433213hoist_
hoists95516023hoists
hokey155422183hoke_y
holey115626903hole_y
homely145313173homely
homey135924843home_y
honesty13378053honesty
honey115629913hone_y
hooey114926603hooe_y
hooty115022433ho_oty
hosey116127023hose_y
hosiery13337183hosiery
joey145719333jo_e_y
joinery17366593joinery
joint125227723joint_
jointly1735483jointly
joints133811453joints
joist125125653joist_
joists134711033joists
jokey195014693joke_y
jolty155713033jo_lty
jotty155012603jo_tty
kilty125213893_kilty
kitty124614563_kitty
laity85318903lai_ty
linty87126563_linty
lofty115813303lo_fty
loiter64619173loiter
lonely92912473lonely
looey84822913looe_y
lovely12339713lovely
lowery124112713lowery
mainly11411493mainly
maist75535673maist_
maists85817573maists
majesty1943503majesty
malty106721703m_alty
mamey125418833mame_y
matey107022663mate_y
meaty107021313m_eaty
meet65350553m_eet_
meetly1138673m_eetly
meets74224613m_eets
meiny104015403mei_ny
melty104918363m_elty
merely111312583merely
met56072433m__et_
meta65932413m__eta
mete64438133m__ete
meth95827843m__eth
middy124812593m_iddy
mien65028353m_ie_n
miens76118303m_iens
miffy163910193m_iffy
mighty154310203mighty
milky144014443m_ilky
milt65455803m_ilt_
milts75430713m_ilts
mincy125817413m_incy
mingy115520183m_ingy
minny104518663m_inny
mint66758043m_int_
mints76834043m_ints
mirky146315523m_irky
mirth106418893m_irth
miry96326743m_i_ry
misery114113543misery
missy105617563m_issy
mist66154523m_ist_
mists76633903m_ists
mite66249403m_i_te
miter75734793m_iter
mites75141803m_ites
mitt66145483m_i_tt
mitts75523753m_itts
mixt136831913m_ixt_
moat66352033mo_at_
moated94819003moated
moats75827643mo_ats
mobility1548543mobility
mockery18376913mockery
mode75840303mode__
model84521693mode_l
models94216353models
modem103717143mode_m
modems114610763modems
modern939523modern
modes85537413mode_s
modest93818453modest
modestly14375583modestly
modify1537173modify
modiste1039283modiste
mofette1296773mofette
moggy125212163mo_ggy
mohel104914833mohe_l
mohels115011323mohels
moieties10311263moieties
moil65534083moi__l
moiled94318863moiled
moiler84017263moiler
moilers93615203moilers
moils76125743moi_ls
moira71012013moi_ra
moirai886913moirai
moire71017313moi_re
moires8915633moires
moisten93110143moisten
moister94015373moister
moke106234223moke__
mokes114631033moke_s
moldy115014653mo_ldy
mole66251833mole__
moles74747923mole_s
molest85022743molest
molests93311563molests
molies84429513molie_s
molly105222493mo_lly
molt66356163mo_lt_
molted94217473molted
molten83311813molten
molter84119423molter
molto75619603mo_lto
molts76032093mo_lts
moly96031913mo__ly
mome85239353mome__
moment103319683moment
momenta11299853momenta
momently1546473momently
momento11348903momento
moments113113123moments
momes95134473mome_s
mommy114010753mo_mmy
monetary1346523monetary
moneys115513623moneys
monie75631653monie__
monied94319463monie_d
monies83233163monie_s
monist84324983monist_
monists93614783monists
monkery16317453monkery
monkey153710593monkey
monody1238243monody
monoecy1445083monoecy
monte75829773mo_nte
montes84226933montes
month104818423mo_nth
mony96830003mo__ny
moody115017493mo_ody
mooed85123983mooe_d
mooley11311633mooley
moony104818273mo_ony
moory105115793mo_ory
moot67653623mo_ot_
mooted94120373mooted
mooter83921093mooter
moots75831663mo_ots
mope86838043mope__
moped105424733mope_d
mopeds11499663mopeds
moper94925923mope_r
mopers104220373mopers
mopes95134983mope_s
mopier103914783mopie_r
mopiest113014293mopiest
moppet126915093moppet_
moppets13307163moppets
mopy115721973mo__py
moray105423793mo_ray
more67154523more__
moreen8313343moreen
morel75729093more_l
morels84820013morels
mores76249643more_s
mort66758833mo_rt_
morts75533563mo_rts
moseys114711703moseys
mossy105217063mo_ssy
most66554203mo_st_
moste75925083mo_ste
mostly113110943mostly
mosts76028543mo_sts
mot57279423mo__t_
mote67048083mo__te
motel76623243mote_l
motels83616893motels
motes75944003mote_s
moth96731333mo__th
mothery153710513mothery
mothy136214553mo_thy
motility1338733motility
motivity1646223motivity
motley1139383motley
mots66853163mo__ts
mott66648443mo__tt
motte75526973mo_tte
mottes85523693mottes
motto76119513mo_tto
motts76527003mo_tts
moue65835573moue__
moues75732843moue_s
mouldy12437413mouldy
moult74728723moult_
moults84713703moults
mount74128063mount_
mounts84115073mounts
mousey115216193mousey
mousy106716943mo_usy
mouth105420293mo_uth
mouthy14409063mouthy
move96630723move__
moved114218153move_d
mover104220863move_r
movers115117193movers
moves106128423move_s
movie105319133movie__
movies115118453movie_s
mowed113629013mowe_d
mower104523453mowe_r
mowers113219403mowers
moxie144018123moxie__
moxies154317403moxie_s
mozetta1894753mozetta
mozette1886773mozette
muleta839233muleta
muley104819283mule_y
musty105620953m_usty
mutely113811653mutely
naivety1344273naivety
nicety1138433nicety
nifty115211633_nifty
nimiety1244633nimiety
ninety9510963ninety
nitty85418313_nitty
noily86120993noi_ly
noisy86813363noi_sy
nonet54540843nonet_
nonets64118703nonets
nosey85619883nose_y
novelty1365173novelty
obey96521303_obe_y
oily77932253_oi_ly
omit65337363omi_t_
omits75018253omi_ts
onery8414123_onery
oogeny10117923oogeny
painty114714753painty
pieta75421753_pieta
pity96031933_pi_ty
poesy105014063po_esy
poet65552903po_et_
poetry1139383po_etry
poets76024443po_ets
pogey116017893poge_y
point75338733point_
pointe84619313pointe
points85618533points
pokey145318973poke_y
polity113015863polity
popery134511703popery
potty105621003po_tty
pouty107018813po_uty
poverty1536433poverty
quiet144530733quiet_
quietly1945883quietly
quiets154014373quiets
roily86121113roi_ly
rooty86423023ro_oty
ropery114313873ropery
ropey106021873rope_y
rosery93813283rosery
roset55945243roset_
rosets65819953rosets
safety12206913safety
satiety1038203satiety
shifty15409253shifty
shirty124312553shirty
shitty124110053shitty
silty84721633_silty
sixty154912733_sixty
skiey125012893skie_y
sleety94112653sleety
slitty9329163slitty
smokey15398653smoke_y
sobriety1343903sobriety
softy115414483so_fty
solely93714213solely
sooey84522433sooe_y
sooty84924833so_oty
sorely94618003sorely
soviet9720153soviet_
soviets1087293soviets
suety85318493_suety
surety93515003surety
thirty12378403thirty
titty85316653_titty
toasty9509563toasty
toilet66228093toilet_
toiletry1144103toiletry
toilets74112913toilets
toit46353063toi_t_
toited74016753toited
toits55327473toi_ts
toney86027413tone_y
towery124012093towery
twisty12426863twisty
unity84918493uni_ty
variety1337743variety
viewy14518103_viewy
volery1237873volery
whitey154911883whitey
whity145513473whi_ty
wifty144212093_wifty
witty114717013_witty
wristy12509703wristy
zooey173914803zooe_y
zooty175415353zo_oty

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164125.01322484.7
3Display Results4124120.1263269.8
 (SQL Overall)1786914125.27933849.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.