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

465 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
mantids10311362(None) 
mantid93820371mantid_
mantis83926031manti_s
antics84621452_antics
antis55033312_anti_s
banties94324762banties
candids113812692candids
canids95118132can_ids
fantods11177622fantods
ganoids939322ganoids
maftirs1236042maftirs
maids86327132ma__ids
malteds10377602malteds
manias84029032man_ias
manics103919932man_ics
manitos9314052manitos
manitus9310922manitus
mantas85725362mant_as
mantels94515042mantels
mantes84430782mant_es
mantic104120902manti_c
mantises10317922mantises
mantissa1044572mantissa
mantles94820702mantles
mantras93815862mantras
mantuas93410992mantuas
martins93322062martins
masjids17175402masjids
mastics112614782mastics
mastoids1177872mastoids
matins84527782ma_tins
mattins93316142mattins
mattoids1196182mattoids
muntins92715132muntins
panties94230932panties
ranids75118702ran_ids
santims9312592santims
santirs7312962santirs
acids87121003_a_cids
actins86321103_actins
aids57846353_a__ids
alcids94812293_alcids
amanitas1048523amanitas
amanitins1147123amanitins
amentias1039403amentias
amids85627503_a_mids
amities9317383amities
amnios84912513amn_ios
ands57833613_an__ds
anils56326723_an_ils
anis45746463_an_i_s
antacids1148323_antacids
antas55432033_ant_as
anted66328243_anted_
antes56334323_ant_es
anti45536363_anti__
antiar6317173_antiar
antiars7314623_antiars
antic75728863_anti_c
antick124814583_antick
anticks134612253_anticks
anting75827023_anting
antings85015583_antings
antres65021003_antres
ants47243473_ant__s
anvils9219713_anvils
aphids125110843_aphids
araneids947743araneids
aroids75118223_aroids
attics84413283_attics
aunties73920073aunties
avoids104410203_avoids
bandies104124863bandies
bandits103814793bandits
bands85233423ban__ds
bankits133410153bankits
bantams1149063bantams
banters94623113banters
batiks1239373ba_tiks
battiks1337143battiks
bawties124214313bawties
caids85226423ca__ids
canards10311203canards
candid104517853candid_
candida114110253candida
candidas12338643candidas
candies104125613candies
canid85526343can_id_
canities101519243canities
cantals93919573cantals
canted94825783canted_
canters94827723canters
canthus1248703canthus
cantic103920533canti_c
cantina93417253cantina
cantinas102713773cantinas
canting104725903canting
cantles94721413cantles
cantons95221203cantons
cantors94620753cantors
cantos84826973cant_os
cantrips12318923cantrips
cants77036943cant__s
cantus85117763cant_us
capsids1239333capsids
carotids11229933carotids
catnips1195893catnips
catties94023053catties
chanties132615803chanties
conoids10813883conoids
cyanids13297933cyan_ids
dainties9312403dainties
dandies94121443dandies
danios7314603dan_ios
dauties83315763dauties
dawties113312703dawties
demantoids1442903demantoids
dentils84115583dentils
dentins83419223dentins
factoids1446243factoids
fanatics1367183fanatics
fancies124018783fancies
fanfics1535173fanfics
fannies103415643fannies
fantails1139693fantails
fantod102010033fantod_
fantoms12189153fantoms
fatties103018203fatties
gadids95611823ga_dids
gadoids1036863gadoids
ganoid8314433ganoid_
gantries91413783gantries
halids104016133ha_lids
haloids113012543haloids
hands95327383han__ds
hankies143617763hankies
hanted104124313hanted_
hanting114124483hanting
hantles104117513hantles
hants86335403hant__s
humanoids1543983humanoids
intis55121633_inti_s
jassids1586143jassids
kanjis1735963kanji_s
kantars11310033kantars
laities7320343laities
lanais6316793lanai_s
lands65426903lan__ds
lattins74115483lattins
lentils73912973lentils
lentoids947443lentoids
mads76845363ma___ds
madtoms1236923madtoms
maenads1037373maenads
maffias15327283maffias
mafias113913573ma_fias
maftir1136493mafti_r
magics115311613ma_gics
magnetics1447163magnetics
magpies12310363magpies
maid75537633ma__id_
mails76037773ma__ils
maims96321783ma__ims
mains75635093ma__ins
maintains1167093maintains
maintops1244403maintops
mairs76228293ma__irs
malkins133311803malkins
malted94819853malted_
malthas1237913malthas
maltier93015483maltier
maltiest102916193maltiest
malting103219083malting
maltols939403maltols
malts76331753malt__s
mamies104626243ma_mies
mammies104314763mammies
manages103418963manages
manakins14209753manakins
mananas93414733mananas
manas76240423man__as
manatees10310423manatees
manatoid1148813manatoid_
manats84623463man_ats
manches143818623manches
mandrils1138483mandrils
maned86634093man_ed_
maneges103612143maneges
manes76648953man__es
mangas94122923man_gas
mangels103614493mangels
mangers103521263mangers
manges94628943man_ges
mangier104114063mangier
mangiest112815903mangiest
mangily1339753mangily
mangles104021463mangles
mangoes104316133mangoes
mangolds1235193mangolds
mangos94319333man_gos
manhoods1447243manhoods
mania75634143man_i_a
maniac103917973man_iac
maniacs114313063maniacs
manic94629433man_i_c
manikins14189723manikins
manila84518303man_ila
manilas93915873manilas
manioc103914823man_ioc
maniocs113611443maniocs
manito8518693man_ito
manitou938463manitou
manitous1039173manitous
manitu8315823man_itu
mankind1437773mankind
manless93012933manless
manlier92414023manlier
manliest102314943manliest
manlike133012783manlike
manlily1238743manlily
manmade1237963manmade
mannans93611523mannans
mannas85019803man_nas
manned94418643manned_
manners93417833manners
manning103616383manning
mannish121710693mannish
mannite9312903mannite
mannites10312613mannites
manors84420883man_ors
manos74933613man__os
mans66354533man___s
mansards1148013mansards
manses84225513man_ses
mansion9611543mansion
mansions1069793mansions
manta75629903mant__a
manteau937863manteau
manteaus1036383manteaus
mantel84317973mant_el
mantilla1048163mantilla
mantillas1147043mantillas
mantissas1143873mantissas
mantle84420923mant_le
mantled104113393mantled
mantlet93620993mantlet
mantlets104611203mantlets
mantling112012603mantling
mantlings12207223mantlings
mantra84116093mant_ra
mantram114011603mantram
mantrams12288963mantrams
mantrap11379823mantrap
mantraps12298063mantraps
mantric11311333mantric
mantua84412023mant_ua
manuals9311213manuals
manumits1246003manumits
manures9313353manures
manus75924923man__us
manwards1447613manwards
manwise1239183manwise
maquis17249483maqui_s
marauds1037553marauds
margins103815193margins
marlins93420473marlins
marrieds11288073marrieds
marries93825283marries
marted94425213marted_
martens93714953martens
martial92415413martial
martian93514683martian
martians103111613martians
martin84122523marti_n
marting103325013marting
martini93613873martini
martinis103311613martinis
marts77442233mart__s
martyrs1234893martyrs
mashies12318253mashies
masjid16187313masjid_
massifs1237743massifs
masted94025803masted_
masters94628923masters
mastic103119173masti_c
mastiff1538163mastiff
mastiffs1644233mastiffs
masting104325823masting
mastitis1039103mastitis
mastix152310503masti_x
mastixes1738253mastixes
mastoid10711223mastoid_
masts77035763mast__s
mated85537783ma_ted_
maters85032383ma_ters
mates75251363ma_t_es
mateys115610943ma_teys
maths105624023ma_t_hs
matier84321523ma_tier
matiest92522453ma_tiest
matilda1044983ma_tilda
matildas1145023ma_tildas
matin75132853ma_ti_n
mating94832913ma_ting
matings104516203ma_tings
matres84522233ma_tres
mats65460283ma_t__s
matted94521413matted_
matters94421753matters
mattes85624533ma_ttes
mattin84416633matti_n
matting103620143matting
mattings11369673mattings
mattoid1079273mattoid_
matts76829183ma_t_ts
matzas1749703ma_tzas
matzos1749263ma_tzos
mauds85519273ma__uds
maundies1137853maundies
maunds9519653ma_unds
mauts75927193maut__s
mavies114923193ma_vies
mavins115119183ma_vins
mavis105622723ma_vi_s
maxims17399673ma_xims
maxis145721563ma_xi_s
maybirds1643323maybirds
mayvins1535323mayvins
mazards1937703mazards
meanies93620743mean_ies
meantime1245983meantime
meantimes1345883meantimes
melanoids1245543melanoids
meloids10911443meloids
menads95514383men_ads
mends84927693men__ds
menhirs1235913menhirs
mentees93214503mentees
mention9314373mention
mentions10312893mentions
mentors9314993mentors
metis75025903m_eti_s
mids76541773m___ids
minds85427123min__ds
minims104514803min_ims
minis75432983min_i_s
minnies93617363minnies
minted94220583minted_
minters93822463minters
mintier93615993mintier
mintiest103217143mintiest
minting103020813minting
mints76834043mint__s
miotics112710653miotics
mitis75425983m_iti_s
monacids13137503monacids
monads94515303mon_ads
monies83233163mon_ies
montes84226933mont_es
months113812933mont_hs
motifs1139673m_otifs
mucoids1237413mucoids
muftis1158053mufti_s
munis75022003mun_i_s
muntin82915183munti_n
munting103718773munting
muntings11289813muntings
murids93212193m_urids
muscids12187973muscids
musjids17185713musjids
myotics14257593myotics
mysids1246563m_ysids
mystics14279103mystics
nancies93516843nancies
nandins8312003nandins
nankins1159053nankins
nannies73015203nannies
nasties73520493nasties
navaids1134803navaids
ootids71110353_ootids
pandies104224503pandies
pandits103914213pandits
panics103815363pan_ics
pansies94521983pansies
panted95024823panted_
pantie84326473panti_e
pantile93918483pantile
pantiles103617153pantiles
panting104025423panting
pantos85222743pant_os
pantries101817393pantries
pants76536923pant__s
parotids112610413parotids
parties93230863parties
pasties94529813pasties
pastils94416173pastils
pastis84924323pasti_s
patins87528783pa_tins
patios85221783pa_tios
patties93425143patties
pentads1039523pentads
peptids12239323peptids
plastids11269203plastids
pongids11347413pongids
pontils9312213pontils
punties94520783punties
qaids156116313qa__ids
quantics19276833quantics
raids65827513ra__ids
ramtils938413ramtils
rancid9513863rancid_
randies84225663randies
rands65930453ran__ds
ranid66429333ran_id_
ranis55235833ran_i_s
ranted74324703ranted_
ranters73323643ranters
ranting84025413ranting
rants55935343rant__s
rapids94913893ra_pids
ratios64922673ra_tios
romantics1346773romantics
saids65328853sa__ids
saiyids11174893saiyids
salpids1038193salpids
salties73725773salties
sands65228583san__ds
sanies63031953san_ies
sanities81219753sanities
santimi938783santimi
santimu938553santimu
santir6315243santi_r
santols73513323santols
santos64421833sant_os
santurs7310763santurs
satins64930483sa_tins
satis55633673sa_ti_s
sayids104310973sa_yids
sayyids14193833sayyids
scanties103215413scanties
semantics1346823semantics
shanties113116573shanties
shantihs14276203shantihs
shantis103313083shanti_s
smarties10312873smarties
tactics1149323tactics
tannins72813223tannins
tansies74521243tansies
tantivy1335563tantivy
tantras73112093tantras
tatties74120343tatties
tineids8337873tineids
untidy1059153_untidy
unties64326923_unties
vanities111414493vanities
wands96425483wan__ds
wanted104319723wanted_
wanters104420093wanters
wanting114220173wanting
wantons103713013wantons
wants87932213want__s
xanthins1846943xanthins
yantras10259003yantras
yautias1046333yautias
zanies153219673zan_ies

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.220812231.8
2DLD Change Limit1340274657.86017051.8
3Display Results4654650.1562980.8
 (SQL Overall)1786914658.23621696.3
 
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.