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

417 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
merinos931198(None) 
merino8315091merino_
eringos836912_eringos
marinas93519382marinas
marines93928012marines
medicos12339832medicos
medinas103411462medinas
merises93421422merises
merisis93213172merisis
merits8320872meri_ts
merlins93015812merlin_s
merlons93311272merlons
mestinos1048162mestinos
mirins83918902mirin_s
morions94014642morions
murines93718222murines
pepinos1137692pepinos
serines74229542serines
serins64029672serin_s
aerials74017553aerials
aeries64737783aeri_es
aerugos834923aerugos
airings83913843airings
albinos937653albinos
amberinas1344613amberinas
amorino9310253amorino_
beanos85516513be_anos
bearings113912253bearings
begins94415303begin_s
behinds1335283behinds
beings94613033be_ings
berimes115216643berimes
berlines102315453berlines
berlins93216013berlin_s
borings103614243borings
brines85028853_brines
brings94618433_brings
brinks124616313_brinks
brins75533973_brin_s
brios74725723_bri_os
burins84221893burin_s
carinas93622403carinas
casinos93512833casinos
cerias83321983ceri_as
cering94522533cerin_g
ceriphs1484753ceriphs
cerises94722253cerises
cerites94823433cerites
ceriums1139473ceriums
ceros74726073cer__os
chinos115018693_chinos
curios83218333curi_os
darings93713653darings
defines114118683defines
derides93420853derides
derives114017813derives
dezincs1933753dezincs
dinos65428063__dinos
dominos103210193dominos
drinks116810713_drinks
durions839963durions
earings84517713earings
eeriness8311873eeriness
eidos65817753_e_idos
elints65816423_elints
emeries91620023emeri_es
emeritas1046433emeritas
emeritus1045173emeritus
emersions1147283emersions
emetines10611053emetines
emetins9812643emetin_s
epinaos936283_epinaos
erenow937373_erenow
ericas8315463_ericas
eringo739553_eringo
eringoes937433_eringoes
ermines9416673_ermines
ernes55224813_er_nes
erns45428223_er_n_s
eros45238453_er__os
erugos7347343_erugos
eryngos1142733_eryngos
eserines8413743eserines
ethnos947053_ethnos
exines135715803_exines
farinas103215233farinas
farinose1136463farinose
feints94813873fe_ints
felines104718073felines
ferias95020393feri_as
ferine96422583ferin_e
fermions1336203fermions
ferns85220083fer_n_s
finos86226953__finos
firings114112333firings
forints10411833forints
gearings10359503gearings
gerents82612923gerents
gerunds935183gerunds
grinds84511843_grinds
gringos936673_gringos
grins65427223_grin_s
hearings123611853hearings
heinous1038853he_inous
helios94816633heli_os
hemins113417563hemin_s
heriot9422343heri_ot
heriots10312063heriots
heritor10310563heritor
heritors11310903heritors
hernias10310773hernias
herns84825583her_n_s
heroines112916573heroines
heroins103518013heroin_s
herons94820543heron_s
heros84930863her__os
herrings12379533herrings
imprints1247303imprints
jarinas143712183jarinas
jerids142810943jeri_ds
jerkins18358253jerkin_s
kenos95220623ke__nos
kernes104717523ker_nes
kerns94719563ker_n_s
kinos96626143__kinos
ladinos8389963ladinos
latinos73613803latinos
legions84611783legions
lenos56024863le__nos
lesions73813863lesions
levins94514653levin_s
linos55631503__linos
madronos11337543madronos
mains75635103m_ain_s
makings145413163makings
malines93625603malines
manitos9314053manitos
manos74933613m__anos
margins103815193margin_s
marina84623413marin_a
marine84230403marin_e
mariner93315993mariner
mariners103113863mariners
mariposa1243703mariposa
markings153410243markings
marlines103818713marlines
marlings113713493marlings
marlins93420473marlin_s
maroons92615553maroons
marranos1038413marranos
marrons93216973marrons
martinis103311613martinis
martins93322063martin_s
matings104516213matings
matins84527783matin_s
mavins115119183mavin_s
mayings134410513mayings
meanies93620743meanies
meanings11329163meanings
means75831223me_an_s
medials103914733medials
medians103214213medians
mediants11299493mediants
medias93620783medi_as
medicks16368413medicks
medico113711163medico_
medics114115353medi_cs
medina94114093medin_a
mediums12308723mediums
medius93613283medi_us
meetings11287413meetings
megilps1233563megilps
megrims1276103megri_ms
meinie82614523me_inie
meinies92516073me_inies
meiny104015413me_in_y
melanous1048603melanous
melenas999203melenas
melilot9311083melilot
melilots1046553melilots
melons84117713melon_s
meltons9410923meltons
mementos12267373mementos
memos95719113me__mos
mendigos12425213mendigos
mendings12338303mendings
mends84927693me__nds
menials94015683menials
meninges1137433meninges
meninx1538703menin_x
meno66031353me__no_
mentions10312893mentions
menudos1034643menudos
menus75822843me__nus
mercers114412773mercers
merces105720743mer_ces
merches144013763merches
mercies113817563mercies
mercs96020453mer__cs
merdes94518603mer_des
meres75143573mer__es
mergees104411233mergees
mergers103813423mergers
merges94122483mer_ges
merging112711763mergin_g
meringue1144333meringue
meringues1244383meringues
merit7339183meri__t
merited10313853merited
merks114722403mer__ks
merles85322763mer_les
merlin83916683merlin__
merlon83012353mer_lon
merlot83217603mer_lot
merlots92710123merlots
merls77423903mer__ls
merriness1138293merriness
mesnes85216213me_snes
mesons83215843meson_s
mestino9411643mestino_
mestinoes1157313mestinoes
mestizos1944493mestizos
methinks1775193methinks
metiers93312843metiers
meting94320593metin_g
metis75025903meti__s
metrics11312363metri_cs
metring103215293metrin_g
metrists1039853metrists
metritis1049183metritis
metros84217803me_tros
mewing123914203mewin_g
mezzos1635043me_zzos
milos75428013m__ilos
minas75434113m__inas
minds85427123m__inds
mines75651953m__ines
minings103912073minings
minions93314623minions
minis75432993m__inis
minks115829273m__inks
minor74920063m__inor
minors85117103m__inors
mints76834043m__ints
minus75223933m__inus
mirin75023153mirin__
miriness10310463miriness
miring93723803mirin_g
misos76523293m__isos
monos75930863m__onos
moorings11257713moorings
moraines10314363moraines
morion86217733mori_on
mornings11297923mornings
morns75527443mor_n_s
morons84919543moron_s
morphos14159083morphos
morrions1077673morrions
morros83714673mor_ros
motions94215003motions
mowings13328483mowings
mucinous1245373mucinous
mucins102712513mucin_s
mureins9310733murein_s
murices112612283murices
murids93212193muri_ds
murine84220023murin_e
muring95120373murin_g
musings10389543musings
mutines93117823mutines
mutinous1047653mutinous
myelines1337123myelines
myelins1237353myelin_s
myriads1334353myriads
myricas1436753myricas
nervines112310463nervines
nervings12256313nervings
neurines8311193neurines
neutrinos943823neutrinos
parings104219213parings
pecorinos1344033pecorinos
peins76128063pe_in_s
pekins121812233pekin_s
pepino10310333pepino_
pereions10310853pereions
pereons92815003pereons
peridot10514243peridot
peridots1138323peridots
perigon1039853perigon
perigons11310083perigons
perilous10310693perilous
perils84121853peri_ls
perinea9313033perinea
period9314983peri_od
periods10312243periods
peris75537073peri__s
peritus9311803peritus
pernio8513143pernio_
pernod9310453per_nod
pernods1038483per_nods
perrons93115483perrons
persons93717013persons
pornos85015253por_nos
primos104514423_primos
prinks124315383_prinks
prints84320103_prints
prions84317783_prions
pterins9812993pterin_s
purines94420763purines
purins83722653purin_s
rebinds104511873rebinds
refinds114512123refinds
refines105426343refines
reginas85614063reginas
regions83613473regions
regrinds1035533regrinds
reinks105012153re_inks
reins56234563re_in_s
relines75331323relines
relinks114510223relinks
reminds104614793reminds
remints95117293remints
renins64526453renin_s
repines94927383repines
repins84924313repin_s
reprints1039903reprints
reredos838633reredos
rerents73319423rerents
rerigs74014793reri_gs
rerises73525883rerises
reruns66413743rerun_s
resinous838503resinous
resins64528773resin_s
retinas74819353retinas
retines75134673retines
retinol7469693retinol
retinols8419743retinols
retints74717013retints
rewinds114810483rewinds
rewins95020823rewin_s
rexines144719153rexines
rhinos94411123_rhinos
rinds64826143__rinds
rings65029173__rings
rinks94827103__rinks
rins46153193__rin_s
sarins63932623sarin_s
seeings84411293seeings
segnos73610443se_gnos
seines65029903se_ines
sereins73716113serein_s
serenes73222903serenes
sergings10299213sergings
serials73919743serials
series64540973seri_es
serifs94017053seri_fs
serin55434443serin__
serine65432673serin_e
sering74731813serin_g
seringa83310743seringa
seringas9339003seringas
serious73616283serious
sermons9311783sermons
serpigos1143843serpigos
serranos857863serranos
servings12249223servings
servos93812723ser_vos
sewings11369173sewings
shrines104618693shrines
shrinks14397913shrinks
sorings83817253sorings
springs104415923springs
sprints94113773sprints
strings84617133strings
technos1236183technos
teinds738263te_inds
teredos839173teredos
terminus1037393terminus
ternes65422903ter_nes
ternion739493ternion
ternions838813ternions
terns55226873ter_n_s
terpinol1044073terpinol
terpinols1143733terpinols
terrines82117533terrines
trigos74214173_trigos
trines64132563_trines
trios55528093_tri_os
tripos84014923_tripos
turions7311573turions
urines64724123_urines
urinose738483_urinose
urinous7310083_urinous
veins84620493ve_in_s
venines103516613venines
venins93816703venin_s
verdins112812333verdin_s
verismos13284693verismos
verisms123011253verisms
verists103613673verists
veritas103012753veritas
verites103822263verites
verminous1445573verminous
versines112213823versines
versions11310353versions
versos93812803ver_sos
vertigos1254973vertigos
vinos84723073__vinos
virions1039873virions
weirdos11355123weirdos
winos84625043__winos
wirings113910113wirings
wrings104012973_wrings
zebranos1943703zebranos
zebrines1935883zebrines
zeins144715393ze_in_s
zeros144918103zer__os

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.266671770.7
2DLD Change Limit1340274178.48315799.5
3Display Results4174170.1562673.1
 (SQL Overall)1786914178.90520066.4
 
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.