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

170 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
mannish121710691mannish
mannas85019802mannas_
mannikin14215502mannikin
manning103616382manning
mannite9312902mannite
mannitic1248012mannitic
mannose939242mannose
mantis83926032mantis_
manwise1239182manwise
tannish101610572tannish
animi74016663_a_nimi
anis45746463_a_nis_
anise55129703_a_nise
anisic8313793_a_nisic
annas55824883_annas_
annuli6459053_annuli
antis55033313_antis_
banish111416043ba_nish
banning103818233banning
banns75321233bann_s_
bennis84314803bennis_
cannas84518403cannas_
cannie83819363canni_e
cannier94014163cannier
canniest10313363canniest
cannikin14196073cannikin
cannily1239263cannily
canning103620133canning
cannoli937263cannoli
canonise10511093canonise
canonist10513533canonist
clannish1345263clannish
danish101513793da_nish
donnish11187633donnish
fannies103415643fannies
fanning113615073fanning
fanwise1336633fanwise
garnish111610843garnish
hennish1336863hennish
hunnish1336163hunnish
jinnis13489053jinnis_
kanjis1735963kanjis_
lanais6316793lanais_
maddish14289483maddish
madness10310073madness
mafiosi1244803mafiosi
magnesia1145723magnesia
magnesic1345753magnesic
magnific1654213magnific
magnify1634533magnify
maidish13239553maidish
mains75635113main_s_
maist75535683ma__ist
malaise9312673malaise
mananas93414733mananas_
manas76240433ma_nas_
manats84623463manats_
manes76648963ma_nes_
mangas94122923mangas_
manges94628943manges_
mangier104114063mangier
mangiest112815903mangiest
mangily1339753mangily
mangos94319333mangos_
mania75634153ma_ni_a
maniac103917973ma_niac
manias84029033ma_nias
manic94629443ma_ni_c
manics103919933ma_nics
manikin132110243ma_nikin
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
mannikins15215093mannikins
mannishly1744113mannishly
mannites10312613mannites
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_
marish114319053ma_rish
martini93613873martini
matins84527783matins_
maunds9519653maunds_
mavins115119183mavins_
mavis105622723ma_vis_
mawkish1935823mawkish
maxis145721563ma_xis_
meanness1037183meanness
menisci1144783m_enisci
minis75432993m_inis_
minish115216303m_inish
miniski1344483m_iniski
minnies93617363minnies
minxish1936213minxish
monish114217593m_onish
monism104016313m_onism
monist84324983m_onist
monkish1638243monkish
moonish123311043moonish
munis75022003m_unis_
munnion935863munnion
nanism8311203na_nism
nannie63713223nanni_e
nannies73015203nannies
nannyish1443303nannyish
nisi45823243___nisi
nunnish1035933nunnish
onanism9310133onanism
onanist7314633onanist
pachisi14329523pachisi
panfish15229973panfish
panini8314273pa_nini
pannes85522853pannes_
pannier93613353pannier
pannikin14194923pannikin
panning104019393panning
pennis84315743pennis_
ranis55235833ra_nis_
rankish14510383rankish
sannyasi1141903sannyasi
santimi938793santimi
tanist6324593ta_nist
tankini11338923tankini
tannest72617853tannest
tannic82811473tanni_c
tannin62613923tanni_n
tanning83618253tanning
tannins72813223tannins
tarnish101611873tarnish
tennis64015303tennis_
tennist72813113tennist
tonnish10149093tonnish
unmannish1443363unmannish
vanish121513213va_nish
vanning113912463vanning
varnish13169533varnish
wanness102610683wanness
wannest103915003wannest
wanning113816213wanning
wennish1336243wennish
zanyish2235903zanyish

Search took 7 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 Limit1340271705.95322514.2
3Display Results1701700.0632698.4
 (SQL Overall)1786911706.42227824.8
 
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.