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

329 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
murrine941148(None) 
murine84220021mu_rine
murrhine1344311murrhine
burring104016992burring
curarine10610712curarine
currie84317262curri_e
curring103616842curring
durrie73713262durri_e
furriner11267302furriner
furring114013142furring
marine84230402m_arine
marline93320952marline
marring103319552marring
moraine9314572moraine
murein8311762murein_
mureins9310732mureins
murines93718222mu_rines
muring95120372mu_ring
murrain937762murrain_
murrains1036852murrains
murre74821072murr__e
murries94118672murries
mutine84420372mu_tine
purine85321892pu_rine
purline93516532purline
purring104515822purring
terrine72517572terrine
turbine9310302turbine
turdine8310282turdine
urine55026592_u_rine
ursine64114122_ursine
acarine9316003acarine
airline7315033airline
arrive91311793_arrive
arsine64021043_arsine
barring104021593barring
berline93716853berline
birring103713063birring
blurring11277233blurring
bourride1144403bourride
brine75132273__brine
brucine1138273brucine
burdie93615023burdi_e
burin75626063bu_rin_
burins84221893bu_rins
burking143716323burking
burkite1337003burkite
burling104421133burling
burnie83715413burni_e
burning104215503burning
burping124012943burping
burrier93613553burrier
burrito936223burrito
burying133413913burying
caprine11314233caprine
carbine112918643carbine
carline93923613carline
carmine112918483carmine
cervine122610803cervine
chorine123218363chorine
churring14298653churring
citrine92514023citrine
corrie83621223corri_e
corvine122113643corvine
cuisine9310423cuisine
cuprite1159683cuprite
curarines11710553curarines
curarize1988853curarize
curbing123814023curbing
curding113515133curding
curiae84518373cu_riae
curie74533043cu_ri_e
curing94824783cu_ring
curite85222943cu_rite
curling104320183curling
curran8312023curran_
currans9310613currans
currant9314173currant
current9313693current
curricle12145933curricle
curried103313653curried
currier93316703currier
curries93723163curries
currish1238353currish
currying14196493currying
cursing104217033cursing
cursive1237833cursive
curving133912103curving
cutline92914543cutline
demurring1335253demurring
dhurrie1153953dhurri_e
dourine8311453dourine
during84419403du_ring
durning93511733durning
durries83817353durries
earring83519013earring
eccrine1137283eccrine
ermine8416923_ermine
errhine1036593errhine
erring73816483_erring
eserine7415903eserine
eucaine939243eucaine
eucrite939903eucrite
ferine96422583_ferine
ferrite103312753ferrite
fluorine1147803fluorine
fulmine1257963fulmine
furane94015493fu_rane
furling114016563furling
furrier103513663furrier
furrily1337603furrily
furriners12316323furriners
furriness12287603furriness
furrings12317143furrings
furtive1337173furtive
garring93116713garring
guanine8810543guanine
gumline102810113gumline
gurging102910113gurging
gurries83515953gurries
guyline11258173guyline
harmine122816193harmine
heroine103517483heroine
herring113615883herring
hircine1239143hircine
hurling113616413hurling
hurricane1443133hurricane
hurried113511043hurried
hurrier103412943hurrier
hurries103919653hurries
hurrying15145533hurrying
hurting113914033hurting
jarring153613193jarring
jurying18337763jurying
larine63927043_larine
latrine7715123latrine
lemurine1046523lemu_rine
lupine84013533lu_pine
lurdane835983lurdane
luring73820753lu_ring
lurking123710853lurking
machine14313493machine
madrone102812663madrone
maline84529083m_aline
margarine1247713margarine
margin94016843margin_
margined1237743margined
margins103815193margins
marina84623413m_arina
mariner93315993m_ariner
marines93928013m_arines
marking144020133marking
marlin84220903marlin_
marlines103818713marlines
marling103322763marling
marlins93420473marlins
marlite92917073marlite
marmite112413993marmite
marrano939423marrano
marriage1147253marriage
married104715303married
marrier93817523marrier
marries93825283marries
marron83717543marron_
marrons93216973marrons
marrying14157223marrying
martin84122523martin_
martinet10319643martinet
marting103325013marting
martini93613873martini
martins93322063martins
merging112711763merging
merino8315093m_erino
merlin83916683merlin_
merlins93015813merlins
merocrine1346233merocrine
merrier92612303merrier
merrily1238633merrily
merriness1138293merriness
metring103215293metring
midline102315103midline
migraine1157863migraine
milline92519113milline
mine67256163m___ine
mirin75023153m_irin_
miring93723803m_iring
mirins83918903m_irins
mitring103514143mitring
moline84422033m_oline
mooring102514443mooring
moraines10314363moraines
morning103215043morning
morphine1548703morphine
morrion959003morrion
morrions1077673morrions
morris83814733morri_s
morrises10711073morrises
mortice11711493mortice
mortise9713533mortise
mourning1156793mourning
mucin93116823mu_cin_
mucins102712513mu_cins
mucking163213823mucking
mucrones1237603mucrones
mudding123310813mudding
muffin14298873muffin_
muffing163210403muffing
muffins15308343muffins
mugging122711793mugging
muggins11248073muggins
muling93519883mu_ling
mulling103819993mulling
mullite9313013mullite
mumming114010023mumming
mumping143411633mumping
mundane1038073mundane
muntin82915183muntin_
munting103718773munting
muntins92715133muntins
murdering1357133murdering
mure65941333mu_r__e
muriate9313363muriate
murices112612283mu_rices
murid84520583mu_ri_d
murids93212193mu_rids
murkier133110273murkier
murkily16287113murkily
murkiness15206293murkiness
murmuring1443633murmuring
murr65225133murr___
murra74519083murr__a
murras84916003murr_as
murrelet10167563murrelet
murres85019043murr_es
murrey114312253murr_ey
murreys12367323murreys
murrha11366453murr_ha
murrhas12286173murrhas
murrs75521293murr__s
murry105120233murr__y
muscarine1346013muscarine
mushing134217633mushing
musing93919503mu_sing
muskie123412543muski_e
muslin8312213muslin_
muslins9312213muslins
muspike1536043muspike
mussing104015543mussing
musting103221073musting
mutined103311353mu_tined
mutines93117823mu_tines
muting93921523mu_ting
mutiny113612683mu_tiny
myeline1238253myeline
nardine82712573nardine
narine63422553_narine
nervine102510623nervine
neurine7311683neurine
nurling84215823nurling
nursing84012553nursing
orpine83914483_orpine
orrice81410163_orrice
ourie54027303ou_ri_e
outline72321333outline
outride82615683outride
outring84021023outring
pardine103616723pardine
parring103222063parring
porcine11312843porcine
puerile9310093puerile
purging113314183purging
purin75527593pu_rin_
purines94420763pu_rines
purins83722653pu_rins
purlin83615863purlin_
purlines103514053purlines
purling103620293purling
purlins93415423purlins
pursing103715553pursing
quercine1964863quercine
quinine163011043quinine
quiring17159993quiring
rusine63916593ru_sine
sardine83317393sardine
scurrile1055063scurrile
serine65432673_serine
shrine94920053_shrine
slurring9288833slurring
sordine82515233sordine
sourdine936893sourdine
spurring11339763spurring
subline9316893subline
subring104116263subring
sunrise7310813sunrise
supine84216693su_pine
surfing112914483surfing
surging93115433surging
surmise9311083surmise
surprint1049533surprint
surprise1037673surprise
surprize1945843surprize
survive1335933survive
tacrine9311293tacrine
tarring83318303tarring
taurine7311363taurine
terrane72814223terrane
terrene72411033terrene
terrines82117533terrines
trine54734603__trine
turbines1039903turbines
turfing113010053turfing
turgite837973turgite
turning83713183turning
undine7817263_undine
unripe82012093_unripe
uprise82313693_uprise
urbane82211383_urbane
ureide7310363_ureide
urging83413123_urging
uridine81311213_uridine
urines64724123_u_rines
urping93914053_urping
uterine7315193uterine
versine102515173versine
vitrine102511363vitrine
vulpine1235903vulpine
warring113717973warring
yirring11307763yirring
zebrine1836463zebrine

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.1731032896.0
2DLD Change Limit1340273298.29616155.6
3Display Results3293290.1262611.1
 (SQL Overall)1786913298.59520790.1
 
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.