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

266 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
mannish12171070(None) 
tannish101610581tannish
banish111416062ba_nish
clannish1345262clannish
danish101513812da_nish
donnish11187632donnish
garnish111610852garnish
hennish1336862hennish
hunnish1336162hunnish
maddish14289482maddish
maidish13239552maidish
mannas85019802mannas_
manning103616382manning
mannishly1744112mannishly
mannite9312902mannite
mannose939242mannose
mantis83926032mantis_
manwise1239182manwise
marish114319062ma_rish
mawkish1935822mawkish
minish115216312m_inish
minxish1936212minxish
monish114217602m_onish
monkish1638242monkish
moonish123311042moonish
nannyish1443302nannyish
nunnish1035932nunnish
panfish15229982panfish
rankish14510392rankish
tarnish101611882tarnish
tonnish10149092tonnish
unmannish1443362unmannish
vanish121513232va_nish
varnish13169552varnish
wennish1336242wennish
zanyish2235912zanyish
aguish1059283_aguish
anguish11117633_anguish
anis45746473_a_nis_
anise55129713_a_nise
ankush13114433_ankush
annas55824883_annas_
antis55033313_antis_
apish105116643_a_pish
aspish114810333_aspish
babyish1736513babyish
bairnish1345473bairnish
baldish1339503baldish
banning103818233banning
banns75321233bann_s_
batfish1558683batfish
bennis84314803bennis_
blandish1497003blandish
brainish1338813brainish
brandish1469023brandish
brinish1239963brinish
burnish1238623burnish
caddish143810133caddish
cannas84518403cannas_
cannie83819363canni_e
cannier94014163cannier
canniest10313363canniest
cannily1239263cannily
canning103620133canning
canonise10511093canonise
canonist10513533canonist
carlish12312773carlish
catfish1559023catfish
cattish12410723cattish
crankish1736513crankish
cronish12310863cronish
dampish1567663dampish
dandyish1644723dandyish
darkish1537943darkish
dronish1138913dronish
duncish1335793duncish
evanish1337673evanish
faddish15359003faddish
faintish1446193faintish
fairish1338993fairish
famish14311853fa_mish
fannies103415643fannies
fanning113615073fanning
fanwise1336633fanwise
fattish1359263fattish
finfish16268193finfish
finish124613423_finish
furnish1337383furnish
garfish14179203garfish
garish104516933ga_rish
gawkish1835833gawkish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
hashish1238353hashish
hawkish2036553hawkish
jadish17319913ja_dish
jinnis13489053jinnis_
kaddish16317973kaddish
kanjis1735963kanjis_
knavish1743993knavish
knish1238623__knish
laddish12299723laddish
ladyish14287823ladyish
lanais6316793lanais_
languish12136253languish
largish1138603largish
larkish1439083larkish
latish92416183la_tish
lavish124112993la_vish
lazyish22265853lazyish
longish11229093longish
madness10310073madness
magnify1634533magnify
mains75635113main_s_
maist75535683ma__ist
malaise9312673malaise
mananas93414733mananas_
manas76240433ma_nas_
manats84623463manats_
manes76648963ma_nes_
mangas94122933mangas_
manges94628953manges_
mangier104114063mangier
mangiest112815903mangiest
mangily1339753mangily
mangos94319343mangos_
mania75634153ma_ni_a
maniac103917973ma_niac
manias84029033ma_nias
manic94629443ma_ni_c
manics103919933ma_nics
manila84518303ma_nila
manioc103914823ma_nioc
manito8518693ma_nito
manitu8315823ma_nitu
mankind1437773mankind
manless93012933manless
manlier92414023manlier
manliest102314943manliest
manlike133012783manlike
manlily1238743manlily
manna75522543mann__a
mannan85413623mann_an
mannans93611523mannans
manned94418643mann_ed
manner84020513mann_er
mannerism1355943mannerism
mannerist1149103mannerist
manners93417833manners
mannikin14215503mannikin
mannites10312613mannites
mannitic1248013mannitic
mannitol1044043mannitol
mannoses1039083mannoses
manors84420883manors_
manos74933623ma_nos_
mans66354553ma_n_s_
manse75528233ma_n_se
manses84225513manses_
mansion9611543mansion
mantas85725363mantas_
mantes84430783mantes_
mantic104120903manti_c
mantid93820383manti_d
mantids103113623mantids
mantises10317923mantises
mantissa1044573mantissa
manus75924933ma_nus_
maquis17249483maquis_
marsh105320853ma__rsh
mash96039403ma___sh
matins84527783matins_
maunds9519653maunds_
mavins115119183mavins_
mavis105622723ma_vis_
maxis145721563ma_xis_
maybush1742453maybush
meanness1037183meanness
mensh105413563m_en_sh
minis75432993m_inis_
minnies93617363minnies
mobbish1635923mobbish
modish123813543m_odish
monism104016313m_onism
monist84324983m_onist
monkfish2044003monkfish
moonfish1675333moonfish
moorish123311783moorish
mopish134311593m_opish
mudfish1646263mudfish
mulish11311903m_ulish
munis75022003m_unis_
munnion935863munnion
nanism8311213na_nism
nannie63713223nanni_e
nannies73015203nannies
ninnyish1442843ninnyish
oafish121311733oa_fish
oarfish13158613oarfish
onanism9310133onanism
onanist7314633onanist
orangish1246553orangish
paganish1447773paganish
palish114718283pa_lish
pannes85522853pannes_
pannier93613353pannier
panning104019393panning
parish115022363pa_rish
pennis84315743pennis_
pinfish15319303pinfish
pinkish16279113pinkish
planish12412063planish
plenish1239943plenish
prankish1737023prankish
punish111411513_punish
punkish16257693punkish
radish103516923ra_dish
raffish1658843raffish
rakish134313973ra_kish
rammish1437563rammish
ranis55235843ra_nis_
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414043ra_vish
rawish123012923ra_wish
runtish1048693runtish
saltish10312163saltish
sandfish1556683sandfish
sawfish1637683sawfish
smallish1346573smallish
standish1238543standish
stonish10410653stonish
sunfish1338883sunfish
swainish1444753swainish
swinish1347203swinish
tallish103313583tallish
tanist6324613ta_nist
tannest72617853tannest
tannic82811483tanni_c
tannin62613933tanni_n
tanning83618253tanning
tannins72813223tannins
tartish101512633tartish
tennis64015303tennis_
tennist72813113tennist
thinnish1454883thinnish
tonish93415913_tonish
townish13167933townish
tundish1137283tundish
unwish1239093_unwish
vampish1766293vampish
vanning113912463vanning
vanquish2343553vanquish
varnishy17163423varnishy
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
wanness102610683wanness
wannest103915003wannest
wanning113816213wanning
warmish1538373warmish
waspish1586923waspish
winish124212273_winish
womanish1646823woma_nish

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.406440125.6
2DLD Change Limit1340272666.61020276.4
3Display Results2662660.0932860.2
 (SQL Overall)1786912667.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.