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 “meow” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

137 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
meow9511788(None) 
meou65325861meou
meows104612681meows
mew86137731me_w
mow86650351m_ow
aeon45634612aeon
alow75328592alow
avow107816462avow
below104617192below
blow95827192blow
bow87051902_bow
brow97228442brow
chow125820992chow
cow89856712_cow
crow96428132crow
dew77139922de_w
dhow116614002dhow
dow76749972_dow
embow1297552embow
enow77819872enow
eon36052082_eon
feod815523002feod
few95436962fe_w
flow105924922flow
frow106425052frow
glow85222522glow
grow86127302grow
hew97642722he_w
how97252432_how
jeon116821442jeon
jew135129082je_w
jow137639302_jow
know116115842know
low66051872_low
maw87050092m_aw
me47748332me__
mead75531602mead
meadow1237402meadow
meal65643172meal
mean65538082mean
meat66359602meat
med66146742me_d
meds75735362meds
meed74934702meed
meek105624832meek
meet65350552meet
meg66040952me_g
mega77620872mega
megs75530632megs
mel56047482me_l
meld75830472meld
mell64935612mell
mellow114112222mellow
melon73922082melon
mels65941532mels
melt65752892melt
mem77943472me_m
meme85330552meme
memo85924792memo
memos95719112memos
mems85931502mems
men59252842me_n
mend75334022mend
meno66031352meno
menu65130222menu
meous76120062meous
meowed12148002meowed
merc87225622merc
mere67244442mere
merk106027942merk
merl65830972merl
mesa67025482mesa
mesh96823002mesh
meson74118312meson
mess65932432mess
met56072432me_t
meta65932412meta
mete64438132mete
meth95827842meth
metol75917812metol
mewl95618322mewl
mews96629332mews
meze154420902meze
mho86624622mho_
mhos95517772mhos
miaow1058352miaow
mo49158482m_o_
moa57249182m_oa
mob78651912m_ob
moc77845082m_oc
mod69054402m_od
mog66949672m_og
mol56654592m_ol
mom78853162m_om
mon57561572m_on
moo58460512m_oo
mood76332062mood
mool67533862mool
moon67140812moon
moor66628552moor
moos66051302moos
moot67653622moot
mop76950822m_op
mor56855002m_or
mos57067122m_os
mot57279422m_ot
mown95424442m_own
mows96340832m_ows
muon65722732muon
neon47026422neon
new66237092ne_w
now65950192_now
ow58950172__ow
peon65635242peon
pew86442302pe_w
plow95923232plow
pow87147282_pow
prow97030382prow
resow88217242resow
row67453672_row
scow96021422scow
serow86720442serow
sew66247262se_w
show106229182show
slow77729492slow
smew95017732sme_w
snow76324792snow
sow66554762_sow
stow77325742stow
tew66640152te_w
tow610557362_tow
trow78031422trow
vow96136312_vow
vrow105817472vrow
wow96643472_wow
yew96436292ye_w
yow96945292_yow

Search took 1 second 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 Filter178691298720.0762351197.4
2DLD Change Limit298721370.86034734.9
3Display Results1371370.0304566.7
 (SQL Overall)1786911370.966184980.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.