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

500 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
manilas9391587(None) 
manias84029031mani_as
manila84518301manila_
manillas102611161manillas
amanitas1048522amanitas
anils56326722_anil_s
animas84418722_animas
anlas55626932_an_las
canolas9313992canolas
canulas9312852canulas
maculas113114012maculas
mafias113913572mafi_as
magilps1234082magilps
mailes84329112ma_iles
maills84215282ma_ills
mails76037772ma_il_s
mananas93414732mananas
manas76240422man__as
mandalas1139432mandalas
mandolas1139132mandolas
mangas94122922man_gas
mangles104021462mangles
mania75634142mani_a_
maniac103917972mani_ac
maniacs114313062maniacs
manics103919932mani_cs
manilla93012472manilla
manille92613272manille
manilles102312592manilles
maniocas12298462maniocas
maniocs113611442maniocs
maniples12269422maniples
manitos9314052manitos
manitus9310922manitus
mannas85019802man_nas
mantas85725362man_tas
mantillas1147042mantillas
mantles94820702mantles
mantras93815862mantras
mantuas93410992mantuas
manuals9311212manuals
maquilas1944032maquilas
marinas93519372marinas
masalas9312052masalas
matildas1145022matildas
maxillas17227702maxillas
menials94015682menials
minilab11126002minilab
minilabs12124572minilabs
ranulas7311772ranulas
vanillas11228122vanillas
agitas7310593_agitas
ails45654713_a_il_s
ajivas1655133_ajivas
akelas10311193_akelas
alas46358123_a__las
alias55834603_ali_as
aliyas93911803_aliyas
amanita9310453amanita_
amias75831463_ami_as
amigas95912163_amigas
amnia75918633amni_a_
amnions93710913amnions
amnios84912513amni_os
amritas939093amritas
anabas8314083_anabas
anas46649863_an__as
ancillas1048033_ancillas
aneles64626293_aneles
angas65827983_an_gas
anginas8310953_anginas
angles74426703_angles
anglos74413903_anglos
anil46437433_anil__
anile54634463_anil_e
anilin6417793_anilin
anilins7416793_anilins
anima74620073_anima_
animal85016253_animal
animals94111703_animals
animes84719593_animes
animis84615943_animis
animus84211613_animus
anions64123033_anions
anis45746463_ani__s
anises64826693_anises
ankles104818383_ankles
annals66415923_annals
annas55824883_an_nas
anoas57226493_an_oas
anoles64827423_anoles
antas55432033_an_tas
anvils9219713_anvil_s
arias55438023_ari_as
arils58732203_aril_s
arnicas939543arnicas
atlas55821583_a_tlas
axillas14278963_axillas
axils127217503_axil_s
bails75933523ba_il_s
baizas173810823ba_izas
balas76937213ba__las
bananas93312223bananas
bandas95120543ban_das
bangles103617413bangles
banian8315383bani_an
banians9312033banians
barillas10310193barillas
basilar937303basilar
basils85717473basil_s
bonitas939453bonitas
cabalas113516003cabalas
callas84526753ca_llas
camisas113411923camisas
canals84421663canal_s
canchas143212403canchas
candelas1139533candelas
candidas12338643candidas
candles104422343candles
canellas10310563canellas
canids95118133cani_ds
canines93724033canines
cannas84518403can_nas
cannulas1037583cannulas
canola8313623canola_
cantalas104013523cantalas
cantals93919573cantals
cantinas102713773cantinas
cantles94721413cantles
canula8312963canula_
canulae9311183canulae
canular9310323canular
canvas113813333can_vas
capias10318353capi_as
carinas93622383carinas
caritas93316943caritas
casitas93312043casitas
cavils114014393cavil_s
dahlias1135723dahlias
dandles94218533dandles
dangles93618423dangles
danios7314603dani_os
denials84114133denials
emails84412333ema_il_s
facials123310743facials
facias113415803faci_as
fails85631483fa_il_s
fajitas1734253fajitas
fanegas1145713fanegas
fangas105017193fan_gas
fanions103713073fanions
farinas103215233farinas
favelas1337023favelas
finials103210153finials
galas65731643ga__las
ganjas14149113gan_jas
gavials1136603gavials
granitas92610223granitas
granolas938053granolas
hails85231643ha_il_s
halalas104214083halalas
handles114020653handles
haniwa1236743haniwa_
hansas94616043han_sas
hantles104117513hantles
hawalas13348353hawalas
jails125422943ja_il_s
jangles154015683jangles
jarinas143712183jarinas
kabalas133911063kabalas
kails95525213ka_il_s
kamalas13339123kamalas
kanakas10327213kanakas
kanas95326913kan__as
labials9299873labials
lamias85020613lami_as
laminas93615873laminas
lanital7310913lanital
lanitals837723lanitals
latillas847363latillas
latinas74416463latinas
mackles154415753mackles
macles107023223ma_cles
macula103013673macula_
maculae113412863maculae
macular113011943macular
macules114015133macules
madeiras1144763madeiras
madras94316423ma_dras
maffias15327283maffias
mafia104418033mafi_a_
magian9312833magi_an
magians10310753magians
magical1239783magical
magics115311613magi_cs
magilp1137613magil_p
magmas115512503ma_gmas
magnolias1244713magnolias
mahonias1348053mahoni_as
maids86327133ma_i_ds
mail65543433ma_il__
mailbag1243923ma_ilbag
mailbags1343903ma_ilbags
maile75232213ma_il_e
mailed95326753ma_iled
mailer84724183ma_iler
mailers94420333ma_ilers
maill74420783ma_il_l
mailman1137733ma_ilman
maims96321783ma_i_ms
mainland1145213mainland
mainlands1244683mainlands
mainly11411493mainl_y
mainmast1245863mainmast
mains75635093ma_i_ns
mairs76228293ma_i_rs
maists85817573ma_ists
maizes175115733ma_izes
makings145413153makings
malar76424443ma__lar
malars85020683ma__lars
males75049793ma__les
malices114316623malices
maligns1038133maligns
malines93625603malines
malls76233433ma__lls
malms95021553ma__lms
malthas1237913malthas
malts76331753ma__lts
mamas95930773ma__mas
mambas125716243ma_mbas
mamies104626243mami_es
mammals10389273mammals
mammas94616403ma_mmas
mana65341943man__a_
manacles1239523manacles
manages103418963manages
manana84816073manana_
manat76039983man__at
manats84623463man_ats
manches143818623manches
manciples1564793manciples
mandala10310203mandala
mandibles1445543mandibles
mandiocas1443943mandiocas
mandola1039023mandola_
mandrills1245453mandrills
mandrils1138483mandril_s
maneges103612143maneges
maneless102812343maneless
manes76648953man__es
manga85026193man_ga_
mangels103614493mangels
mangers103521263mangers
manges94628943man_ges
mangily1339753mangil_y
mangle93921323mangl_e
mangled113615253mangled
mangler103215643mangler
manglers113311903manglers
mangoes104316133mangoes
mangolds1235193mangolds
mangos94319333man_gos
manholes13311183manholes
maniacal1246723maniacal
manic94629433mani__c
manifest1339503manifest
manifolds1583673manifolds
manihot121112053manihot
manihots13126443manihots
manikin132110243manikin
manikins14189723manikins
manioc103914823mani_oc
manioca11358943manioca
maniple11249653maniple
manipular1344223manipular
manipulars1453133manipulars
manito8518693mani_to
manitou938463manitou
manitous1039173manitous
manitu8315823mani_tu
manless93012933manless
manlier92414023manlier
manliest102314943manliest
manlike133012783manlike
manlily1238743manlily
manly105022943man_l_y
manna75522533man_na_
mannan85413623man_nan
mannans93611523mannans
manners93417833manners
mannites10312613mannites
manors84420883man_ors
manos74933613man__os
mans66354533man___s
manses84225513man_ses
mansions1069793mansions
manta75629903man_ta_
manteau937863manteau
manteaus1036383manteaus
mantels94515043mantels
mantes84430783man_tes
mantids103113623mantids
mantilla1048163mantilla
mantis83926033man_tis
mantises10317923mantises
mantissa1044573mantissa
mantissas1143873mantissas
mantle84420923mantl_e
mantled104113393mantled
mantlet93620993mantlet
mantlets104611203mantlets
mantra84116093mantra_
mantram114011603mantram
mantrams12288963mantrams
mantrap11379823mantrap
mantraps12298063mantraps
mantua84412023mantua_
manual8313463man_ual
manures9313353manures
manus75924923man__us
maples104819423ma_ples
maquila1844703maquila_
maracas11313773maracas
maras75443283ma__ras
marbles114516653marbles
maria75032883mari_a_
marimbas1444363marimbas
marina84623413marina_
marines93928013marines
marital92314183marital
markas124717003ma_rkas
markkas12356083markkas
marlins93420473marlins
marls75535163ma_rl_s
marsalas1038253marsalas
masala8311813masala_
masas75630413ma__sas
massas85116463ma_ssas
matilda1044983matilda
matinal9312603matinal
matings104516203matings
matins84527783mati_ns
matzas1749703ma_tzas
mauls76524953ma_ul_s
mavies114923193mavi_es
mavins115119183mavi_ns
mavis105622723mavi__s
mavises122812993mavises
maxilla16248193maxilla
maxillae17256723maxillae
maxima17568633maxima_
maximal18347093maximal
maximals19325223maximals
maxims17399673maxi_ms
maxis145721563maxi__s
maxixes1535253maxixes
mayas105924383ma__yas
mayings134410503mayings
mazily20610393mazil_y
mazumas2034623mazumas
mbiras1077143m_biras
meanies93620743meani_es
meanings11329153meanings
medials103914733medials
medias93620783medi_as
medinas103411463medinas
megillas1145893megillas
megilps1233563megilps
menial84223033meni_al
mensas85115853men_sas
micas96823053m__icas
milds86422053m__ilds
miles74645073m__iles
milks115020583m__ilks
mills75435053m__ills
milos75428013m__ilos
milpas101710273m__ilpas
mils66045323m__il_s
milts75430713m__ilts
minas75434113m__inas
mingles103719003mingles
minibar11106123minibar
minibars1296543minibars
minibus1136323minibus
minicab13177163minicab
minicabs14135063minicabs
minicam131110053minicam
minicams14126863minicams
minicar11109313minicar
minicars12118503minicars
minima105512633minima_
minimal114010593minimal
minimals12327423minimals
minimax18376003minimax
minims104514803mini_ms
minings103912073minings
minions93314623minions
minis75432983mini__s
miniums113910213miniums
minivan1245713minivan
minivans1345413minivans
mobiles112813123mobiles
mochilas1544943mochilas
moils76125743m_oil_s
molas75132093m__olas
monas74732153mon__as
monies83233163moni_es
monisms113512803monisms
monists93614783monists
moolas83615593m_oolas
morulas959703morulas
motiles93317433motiles
moviolas1344513moviolas
mullas84215933m_ullas
munis75022003muni__s
mynas105815233myn__as
myricas1436743myricas
nails55730403na_il_s
nairas6312773na_iras
nalas55528363__nalas
nanas55928633nan__as
nandinas936573nandinas
nanisms938833nanisms
nills54926673__nills
nils46132453__nil_s
nipas77116673__nipas
paellas9411413paellas
pails75833063pa_il_s
paisas84317493pa_isas
panadas103312213panadas
panamas113112753panamas
pandas95521963pan_das
panels84716523panel_s
pangas99921103pan_gas
panicles121010103panicles
panics103815363pani_cs
paniers94717333paniers
pantiles103617153pantiles
patinas96318523patinas
payolas12148973payolas
qabalas18289503qabalas
radials83614633radials
radulas839583radulas
raias54631123ra_i_as
rails55937403ra_il_s
raitas64417673ra_itas
ramblas112710263ramblas
ranids75118703rani_ds
ranis55235833rani__s
rankles113114543rankles
ranula6311813ranula_
ranular739433ranular
saigas74114293sa_igas
sails55738103sa_il_s
salinas73116093salinas
salivas10309603salivas
sandals82715203sandals
sangas75222653san_gas
sanicles10149943sanicles
sanies63031953sani_es
sanious7514103sanious
seniles72618023seniles
sheilas1059403sheilas
snails64816653snail_s
tablas83716163ta_blas
taenias7311283taeni_as
tafias93111963tafi_as
taigas73712553ta_igas
tails55634193ta_il_s
talas55935893ta__las
tangles83920043tangles
tanists7313653tanists
tankas104613763tan_kas
tantras73112093tantras
tenias64720073teni_as
uranias72113813urani_as
vaginas11298813vaginas
vails85825933va_il_s
vakils1337593vakil_s
vandals113211663vandals
vandas103915993van_das
vanilla10238743vanilla
varias95019903vari_as
variolas1168533variolas
wails86631483wa_il_s
wallas95719393wa_llas
wangles113416933wangles
wanigan1135213wanigan
wanigans1244743wanigans
wanions104011373wanions
xenias133712973xeni_as
yantras10259003yantras
zamias174212923zami_as
zananas16319563zananas
zanies153219673zani_es
zanily18310183zanil_y
zanzas1487053zan_zas
zaribas1836043zaribas
zonulas1637023zonulas

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.1401276364.3
2DLD Change Limit1340275007.72017361.0
3Display Results5005000.1732890.2
 (SQL Overall)1786915008.03322244.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.