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

183 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
moieties1031126(None) 
gaieties9310182gaieties
impieties1345962impieties
modesties1247472modesties
mofettes1386082mofettes
monetise10311472monetise
monetises11311042monetises
monetizes2049262monetizes
moperies12313872moperies
pieties9419222_pieties
societies1148802societies
ubieties1046912ubieties
amities9317383ami_ties
anxieties1646263anxieties
ariettes8411353ariettes
bhisties1339003bhisties
boiseries11411043boiseries
boites84322703boi_t_es
boletes9316063bolet_es
booties94124613bo_oties
bounties10311403bounties
boweries13312293boweries
chitties13310773chitties
cities84524853_ci_ties
comedies13311843comedies
comities12317793comities
coonties10513803coonties
cooties93725733co_oties
coteries10422703coteries
counties10316283counties
dainties9312403dainties
deities82621923dei_ties
dioecies1138933dioecies
dirties83119383_dirties
ditties83116983_ditties
doilies84017363doi_lies
dovekies16115003dovekies
doweries12411933doweries
dubieties1245283dubieties
fifties132111083_fifties
footies103721543fo_oties
foretimes1447453foretimes
forties104323863fo_rties
fouettes1137883fouettes
gayeties1236883gayeties
godetias1045343godetias
goitres8389563goi_tres
hogties112813993ho_gties
honesties1249913honesties
hosieries1249213hosieries
hotties103016963ho_tties
joineries1648103joineries
kilties113014143_kilties
kitties113213623_kitties
laities7320343lai_ties
lovelies1139893lovelies
majesties1845373majesties
meinies92516073mei_nies
memetics1447803memetics
metes74736213m__et_es
metier83517693m__etier
metiers93312843m__etiers
metis75025903m__eti_s
metres85121563m__etres
middies113116153m_iddies
miltier93214963m_iltier
miltiest103015173m_iltiest
mimetites1346823mimetites
minnies93617363m_innies
mintier93615993m_intier
mintiest103217143m_intiest
miotics112710653m_iotics
miseries10320403miseries
mislies92922283m_islies
missies93423983m_issies
mistier93418713m_istier
mistiest103018313m_istiest
mistimes12612613m_istimes
mites75141803m_i_t_es
mitier83620673m_i_tier
mitiest93520053m_i_tiest
mitis75425993m_i_ti_s
mitises9315543m_i_tises
mitres83922073m_i_tres
mobilities1449833mobilities
mockeries17128263mockeries
modernes1138423modernes
modifies1439163modifies
modistes1138643modist_es
mofette1296773mofette_
moffettes1743463moffettes
moggies113111723mo_ggies
moidores1156343moidores
moiety1148223moiet__y
moires8915633moi__res
moisten93110143moist_en
moistens10268773moistens
moister94015373moist_er
moistest1038763moist_est
moistness1146343moistness
moistures1147323moistures
molies84429513mo__lies
mollies93420233mo_llies
momentoes13286253momentoes
mommies103912273mo_mmies
monetised1246973monetised
monetize1949983monetize
monetized2147153monetized
monies83233163mo__nies
monkeries15129913monkeries
monodies11312503monodies
monoecies1348863monoecies
montes84226933mo_nt_es
moquettes2044643moquettes
morelles10710493morelles
mortices12711563mo_rtices
mortise9713533mo_rtise
mortises10713613mo_rtises
motes75944003mo__t_es
motets84216193motet__s
motifs1139673mo__tifs
motiles93317433mo__tiles
motilities12410583motilities
motives123611893mo__tives
motivities1547693motivities
mottes85523693mo__ttes
mottles93415803mo_ttles
mottoes93412193mo_ttoes
movies115118453mo__vies
moxies154317403mo__xies
mozettas1993543mozettas
mozette1886773mozette_
musettes1037433musettes
naiveties1245433naiveties
niceties10310863niceties
nifties102612503_nifties
nimieties1145223nimieties
nineties8312913nineties
noisettes946533noisettes
novelties1245983novelties
oogenies9311583oogenies
pities83828083_pi_ties
poesies93217403po_esies
poetics11312073po_etics
poetise9314043po_etise
poetises10313953po_etises
poetizes19310253po_etizes
poetries10315583po_etries
pointes93216753point_es
pointier1038303pointier
pointiest1139623pointiest
polities102722343polities
poperies12316793poperies
posties93128813po_sties
potties93723543po_tties
poverties1439513poverties
reties65436193__reties
roperies10315763roperies
roseries8317313roseries
rosettes8310343rosettes
safeties1139163safeties
satieties939383satieties
sixties14310973_sixties
sobrieties1244293sobrieties
softies103414613so_fties
sometimes1345993sometimes
sorties74126403so_rties
sovietizes2243543sovietizes
sureties8316583sureties
sweeties11159723sweeties
thirties1139723thirties
titties73617363_titties
toiletries1046613toiletries
toilettes946023toilettes
tonetics1048943tonetics
tonettes839203tonettes
unities72520153uni_ties
varieties1259203varieties
voleries11313233voleries
whities133113253whi_ties
wienies102213683_wienies
zoisites1744973zoisites
zonetimes2044203zonetimes

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 Limit1461621836.48322545.4
3Display Results1831830.0762407.9
 (SQL Overall)1786911836.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.