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

240 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
manwise123918(None) 
fanwise1336631fanwise
anise55129702_an_ise
anywise1345202_anywise
malaise9312672malaise
manlike133012782manlike
mannish121710692mannish
mannite9312902mannite
mannose939242mannose
manse75528232man__se
mantis83926032mantis_
mantises10317922mantises
sunwise1036432sunwise
taxwise1734252taxwise
unwise9510802_unwise
advise10139223_advise
airwise1036713airwise
amandine1148553amandine
anile54634463_an_ile
anime75423203_an_ime
anis45746463_an_is_
anises64826693_an_ises
antis55033313_antis_
antisex1439693_antisex
arise56436433_a_rise
bandies104124863bandies
banish111416043ban_ish
banties94324763banties
baptise1139553baptise
bendwise1443413bendwise
camise103319633ca_mise
canalise10816213canalise
candies104125613candies
canine83826703can_ine
cannie83819363canni_e
canonise10511093canonise
concise11314473concise
crabwise1543613crabwise
dandies94121443dandies
danish101513793dan_ish
endwise1136463endwise
fancies124018783fancies
fanlike142610503fanlike
fannies103415643fannies
fanzine1937123fanzine
flatwise1443973flatwise
gawsie1038463ga_wsie
genoise839423genoise
hankie133915713hanki_e
hankies143617763hankies
hanse85722793han__se
hawse116015123ha_w_se
haywire1644743haywire
humanise1348513human_ise
incise83515333_incise
ionise63516943ion_ise
kanjis1735963kanjis_
kyanise14236143kyan_ise
laicise939333laicise
lanais6316793lanais_
lanose6313593lan_ose
lauwine1036373lauwine
lawine93316463la_wine
longwise1244083longwise
machine14313493machine
maddish14289483maddish
magnetise125110403magnetise
magpie1139093magpi_e
magpies12310363magpies
maidish13239553maidish
maile75232223ma__ile
mainline1039863mainline
maist75535683ma__ist
maize164618563ma__ize
malaises10312333malaises
malice104818483ma_lice
maline84529083ma_line
maltase938903maltase
maltose939783maltose
mamie95826003ma_mi_e
mamies104626243ma_mies
mammie94313783mammi_e
mammies104314763mammies
manacle11310283manacle
manage93818903man_age
manages103418963manages
manas76240433man_as_
manatee9317663manatee
manats84623463manats_
manche133515103man_che
manches143818623manches
manciple1445093manciple
mandate10315573mandate
mandible1337543mandible
mane65052033man___e
manege94113203man_ege
maneges103612143maneges
manes76648963man_es_
mangas94122923mangas_
mange84930193man__ge
manges94628943manges_
mangier104114063mangier
mangiest112815903mangiest
mangily1339753mangily
mangle93921323man_gle
mangles104021463mangles
mangoes104316133mangoes
mangos94319333mangos_
manhole12311343manhole
mania75634153man_i_a
maniac103917973man_iac
manias84029033man_ias
manic94629443man_i_c
manics103919933man_ics
manila84518303man_ila
manille92613273manille
manioc103914823man_ioc
maniple11249653maniple
manito8518693man_ito
manitu8315823man_itu
mankind1437773mankind
manless93012933manless
manlier92414023manlier
manliest102314943manliest
manlily1238743manlily
manmade1237963manmade
mannas85019803mannas_
manning103616383manning
mannites10312613mannites
mannoses1039083mannoses
manors84420883manors_
manos74933623man_os_
manque17259513man_que
manrope1138033manrope
mans66354553man__s_
manses84225513man__ses
mansion9611543mansion
mantas85725363mantas_
mantes84430783mantes_
mantic104120903manti_c
mantid93820383manti_d
mantids103113623mantids
mantissa1044573mantissa
mantle84420923man_tle
mantles94820703mantles
manure8313653man_ure
manures9313353manures
manus75924933man_us_
manward1349093manward
maplike15299273maplike
maquis17249483maquis_
marine84230403ma_rine
marish114319053ma_rish
marline93320953marline
marlite92917073marlite
marmite112413993marmite
marquise19206173marquise
marries93825283marries
marse76231153ma__rse
mashie11315933mashi_e
mashies12318253mashies
masse75125293ma__sse
massive12289773massive
maundies1137853maundies
mavie104722563ma_vi_e
mavies114923193ma_vies
mavis105622723ma_vis_
mavises122812993ma_vises
mawing124020803ma_wing
mawkish1935823mawkish
maws96437143ma_w_s_
maximise1944913maximise
maxis145721563ma_xis_
maxixe1435223ma_xixe
meanie83718393mean_i_e
meanies93620743mean_ies
meantime1245983meantime
meanwhile1752063meanwhile
mense75025633men__se
midwife16225523midwife
minimise1246863minimise
minis75432993min_is_
minish115216303min_ish
minnies93617363minnies
minxish1936213minxish
mise66043583m___ise
monetise10311473monetise
monie75631653mon_i_e
monies83233163mon_ies
monish114217593mon_ish
monism104016313mon_ism
monist84324983mon_ist
monkish1638243monkish
moonrise1046783moonrise
mortise9713533mortise
munis75022003mun_is_
nancies93516843nancies
nanism8311203nan_ism
nannie63713223nanni_e
nannies73015203nannies
noise55723733__noise
nowise9511073_nowise
paise75028333pa__ise
palewise1346423palewise
pandies104224503pandies
panfish15229973panfish
panpipe1034833panpipe
pansies94521983pansies
pantie84326473panti_e
panties94230933panties
pantile93918483pantile
parvise124211693parvise
pavise114714803pa_vise
raise54828053ra__ise
randies84225663randies
ranis55235833ran_is_
rankish14510383rankish
ranpike1335933ranpike
rawish123012913ra_wish
romanise10312133roman_ise
sanies63031953san_ies
sanitise81511813sanitise
slantwise1242633slantwise
sunrise7310813sunrise
tanist6324593tan_ist
tannish101610573tannish
tansies74521243tansies
tawie84819813ta_wi_e
tawnies102812503tawnies
tawse85616503ta_w_se
umangite1144823umangite
unwiser1037123_unwiser
unwish1239093_unwish
valise92917643va_lise
vanish121513213van_ish
warpwise1642853warpwise
wise75737343___wise
womanise1348733woman_ise
zanies153219673zan_ies
zanyish2235903zanyish

Search took 9 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.483369960.7
2DLD Change Limit1340272407.31318327.2
3Display Results2402400.2031182.3
 (SQL Overall)1786912407.99922339.2
 
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.