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

205 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
maniple1124965(None) 
manciple1445091manciple
manille92613271manille
maniples12269421maniples
anile54634462_ani_le
maile75232222ma_i_le
manacle11310282manacle
manciples1564792manciples
mandible1337542mandible
mangle93921332man_gle
manhole12311342manhole
manila84518302mani_la
manilla93012472manilla
manilles102312602manilles
mantle84420922man_tle
maple95521142ma__ple
panicle11129982panicle
sanicle91210262sanicle
agile65122263_agi_le
aisle55223193_a_isle
alible8311973_alible
amniote936963amniote
ample94720303_a_mple
anele55628833_an_ele
angle64528883_an_gle
anil46437433_ani_l_
anils56326723_ani_ls
anime75423203_ani_me
anise55129713_ani_se
anisole71010833_anisole
ankle95220253_an_kle
anole55330383_an_ole
antipole10910153_antipole
apple94517673_a_pple
axile126020513_axi_le
bangle94018963ban_gle
calicle113111433calicle
calipee11412913calipee
canaille1048413canaille
canape10913523canap_e
candle94321483can_dle
canine83826703cani_ne
canticle1239703canticle
cantle84522153can_tle
cariole9818343cariole
dandle84218093dan_dle
dangle84119313dan_gle
dapple1138853da_pple
dariole8711163dariole
enisle63412093_enisle
exciple1874683exciple
facile112514883faci_le
faille93414743fa_ille
funicle12237483funicle
habile11515213habi_le
handle104219293han_dle
hantle94318203han_tle
jangle144416303jan_gle
kantele1138253kantele
labile8315223labi_le
mackle143716433ma_ckle
macle96127003ma__cle
macule104115273ma_cule
magilp1137613magi_lp
magilps1234083magilps
magpie1139093ma_gpie
maigre9309163ma_igre
mail65543453ma_i_l_
mailed95326753ma_i_led
mailer84724183ma_i_ler
mailes84329113ma_i_les
maill74420793ma_i_ll
maills84215283ma_ills
mails76037783ma_i_ls
mainly11411493ma_inly
maize164618563ma_i_ze
makable15510203makable
male66052303ma___le
malice104818483mali_ce
maline84529093mali_ne
mamie95826003mami__e
manacled1336453manacled
manacles1239523manacles
manage93818903man_age
manatee9317663manatee
manche133515103man_che
mandala10310213mandala
mandate10315573mandate
mandibles1445543mandibles
mandola1039023mandola
mandrel1038683mandrel
mane65052033man___e
manege94113203man_ege
manful11610213manful_
mange84930203man__ge
mangel94017543mangel_
mangels103614493mangels
mangily1339753mangily
mangled113615263man_gled
mangler103215643man_gler
mangles104021463man_gles
mangold1137213mangold
manholes13311183manholes
mania75634153mani__a
maniac103917973mani_ac
maniacs114313063maniacs
manias84029033mani_as
manic94629443mani__c
manics103919933mani_cs
manicure1245803manicure
manifold1484943manifold
manihot121112053manihot
manikin132110243manikin
manilas93915873manilas
manillas102611163manillas
manioc103914823mani_oc
manioca11358943manioca
maniocs113611443maniocs
manipular1344233manipular
manipulate1445163manipulate
manito8518693mani_to
manitos9314053manitos
manitou938463manitou
manitu8315823mani_tu
manitus9310923manitus
manlike133012783manlike
manlily1238743manlily
manly105022953man__ly
manmade1237963manmade
mannite9312903mannite
mannose939243mannose
manque17259513man_que
manrope1138033manrope
manse75528233man__se
mantel84317973mantel_
mantelet10613823mantelet
mantels94515043mantels
mantilla1048163mantilla
mantled104113393man_tled
mantles94820703man_tles
mantlet93620993man_tlet
manual8313463manual_
manuals9311223manuals
manure8313653man_ure
manwise1239183manwise
manyplies1643893manyplies
maples104819423ma__ples
marble104219103ma_rble
marine84230413mari_ne
matinee92415613matinee
mavie104722563mavi__e
maxilla16248193maxilla
maxillae17256723maxillae
maxixe1435223maxi_xe
mayapple1741703mayapple
maypole1446383maypole
mazily20610393mazi_ly
meanie83718393meani__e
meikle1236653m_eikle
menial84223033menial_
menials94015693menials
mile66352583m__i_le
mille75029133m__ille
minable112315073minable
mingle93518783min_gle
minipill1244353minipill
mixible18195093mixible
mobile103613543mobi_le
monie75631653moni__e
monocle1139663monocle
monopole1249283monopole
motile83818343moti_le
mouille937843mouille
multiple12118303multiple
nipple103410373__nipple
nonuple946153nonuple
panicled13106783panicled
panicles121010133panicles
panoply1434713panoply
panpipe1034833panpipe
pantile93918483pantile
penile82219603peni_le
radiale83813523radiale
radicle103510713radicle
rankle103414883ran_kle
ranpike1335933ranpike
sample104215013sa_mple
sandpile1146773sandpile
sanicles10149943sanicles
senile63420213seni_le
snipe75320573_snip_e
swiple11379233_swiple
taille63116923ta_ille
tangible1145603tangible
tangle74019973tan_gle
triple84215923_triple
tunicle9308033tunicle
unpile81914323_unpile
vagile10310543vagi_le
vanilla10238753vanilla
variole10711593variole
wandle105316663wan_dle
wangle103817513wan_gle
wavicle1534063wavicle
zanily18310183zani_ly

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.390458182.1
2DLD Change Limit1340272056.29621287.6
3Display Results2052050.0633254.0
 (SQL Overall)1786912056.74926476.7
 
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.