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

166 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
manifest133950(None) 
manifesto1442741manifesto
manifests1444121manifests
mangiest112815902mangiest
manifested1642972manifested
manifester1543132manifester
manifestly1852202manifestly
manifestos1552242manifestos
manliest102314942manliest
matiest92522452mati_est
maziest183613872mazi_est
waniest103819112wani_est
zaniest163214772zani_est
airest63825263_a_irest
anapest9311553_anapest
animes84719593_animes_
animist93815173_animist
anises64826693_anises_
aridest8316143_aridest
babiest114414753babi_est
barniest104815053barni_est
boniest93318993boni_est
cagiest102916433cagi_est
cakiest133215663caki_est
candidest1346533candidest
canines93724033canines_
canniest10313363canniest
daffiest1537843daffiest
dandiest103415033dandiest
dankest122611673dan_kest
easiest72318773easi_est
fainest10417703fa_inest
faintest1139073faintest
fairest10412293fa_irest
fanciest133612713fanciest
fawniest14287443fawni_est
funfest13348083fun_fest
gabfest1336453ga_bfest
gamiest102816223gami_est
handfast1546733handfast
handiest123417773handiest
hangnest12311413hangnest
haziest193313003hazi_est
infest93315433_in_fest
knifes136210213_knifes_
laciest93819033laci_est
lakiest113517263laki_est
lankest112714113lan_kest
lankiest122912493lankiest
laziest163814473lazi_est
liniest73321153lini_est
luniest73516993luni_est
maddest112311213ma_ddest
magnifies1547283magnifies_
mailes84329113ma_iles_
mainmast1245873mainmast
maist75535683ma_i__st
maizes175115733ma_izes_
makefast1743293makefast
malices114316623malices_
malines93625603malines_
malmiest123211023malmiest
maltiest102916193maltiest
mamies104626243mami_es_
manages103418963manages_
manches143818623manches_
manchet143317773manche_t
manchets15269573manchets
maneges103612143maneges_
maneless102812343maneless
manes76648963man__es_
manges94628943man_ges_
manginess122010413manginess
mangles104021463mangles_
mangoes104316133mangoes_
maniacs114313063maniacs_
manias84029033mani_as_
manics103919933mani_cs_
manifestant1662503manifestant
manifesters1652753manifesters
manifesting1762733manifesting
manifestoed1751513manifestoed
manifestoes1651973manifestoes
manifold1484943manifold
manihot121112053mani_hot
manihots13126443manihots
manilas93915873manilas_
manilles102312603manilles_
maniocs113611443maniocs_
maniples12269423maniples_
manitos9314053manitos_
manitus9310923manitus_
manless93012933man_less
manliness111310123manliness
mannites10312613mannites_
manses84225513man_ses_
mantes84430783man_tes_
mantises10317923mantises_
mantles94820703mantles_
mantlet93620993mantle_t
mantlets104611203mantlets
manures9313353manures_
marines93928013marines_
marliest102415183marliest
massiest103314423massiest
matiness102114753matiness
maturest1039693maturest
mavies114923193mavi_es_
mavises122812993mavises_
maxixes1535253maxixes_
mayest114614793ma__yest
maziness19239543maziness
mealiest102215973meali_est
meanest9315703mean__est
meanies93620743meani_es_
meatiest102816793meati_est
miffiest1637133miffiest
minciest122913103minciest
mingiest113315823mingiest
minifies13312903minifies_
mintiest103217143mintiest
minutest10247653minutest
miriest93619823miri_est
mitiest93520053miti_est
monies83233163moni_es_
monist84324983moni__st
mooniest103014173mooni_est
mopiest113014293mopi_est
muniment1248943muniment
naivest10309473na_ivest
nicest82315663__nicest
oakiest112913923oaki_est
paciest112917803paci_est
pacifist1548093pacifist
paliest93021603pali_est
piniest93121133pini_est
puniest92918093puni_est
raciest92820013raci_est
rainiest81214923rainiest
randiest93418773randiest
rangiest93115983rangiest
rankest112713813ran_kest
rapidest1138543rapidest
rifest93114583__rifest
safest95016603sa__fest
sagiest82617983sagi_est
sandiest93218683sandiest
sanest64426693san__est
sanies63031953sani_es_
snidest8310913_snidest
songfest1236843songfest
tangiest92915223tangiest
tanist6324593tani__st
tannest72617853tan_nest
tawniest11279343tawni_est
tiniest73020123tini_est
toniest73218903toni_est
vainest10315763va_inest
viniest103216613vini_est
wannest103915003wan_nest
wariest105122503wari_est
waviest134513073wavi_est
waxiest173510883waxi_est
winiest103419693wini_est
zanies153219673zani_es_
zaniness1738663zaniness

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.420425454.8
2DLD Change Limit1461621667.45319611.2
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.93622516.5
 
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.