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

168 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
metump123571(None) 
metumps1334131metumps
bethump1642822bethump
getup83410262getu_p
letup73712162letu_p
mentum104511712mentum_
mump105425722m__ump
repump1235682repump
setup73915822setu_p
stump94616462_stump
tump85927032__tump
acetum1038463acetum_
autumn836013autumn
bedumb1335063bedumb
begum105213923begum_
begums11429493begums
benumb1235773benumb
bethumps1741993bethumps
betime105914833betime
bump106228243__bump
cecum11611843cecum_
centum104012363centum_
centums11398783centums
chump145315443_chump
clump115517453_clump
crump115616423_crump
cutup9410093cutu_p
datum8310633datum_
datums936353datums
decamp1338453decamp
degum94711903degum_
degums10438623degums
dump95927093__dump
equip16467263_equip
etude63612303_etude
etui45416233_etu_i
etuis54013133_etuis
etyma1036583_etyma
fetus85816543fetu_s
flump124614723_flump
frump126912563_frump
gazump2032453gazump
getups9346853getups
geum75424553ge_um_
geums85414113ge_ums
grump105115313_grump
heaume1137543heaume
hemp115725623he__mp
hump116228723__hump
jump156621723__jump
kemp126418763ke__mp
legume936913legume
letups8317683letups
lump86531703__lump
mature8313463mature
mazuma1935603mazuma
meatus85112923meatu_s
medium113711623medium_
mediums12308723mediums
medusa936293medusa
megilp1135833megilp
mem77943473me__m_
meme85330553me__me
memo85924793me__mo
mems85931503me__ms
menu65130223menu__
menudo945793menudo
menus75822843menu_s
meou65325863meou__
meoued9118533meoued
meous76120063meou_s
met56072433met___
meta65932413met__a
metage93114453metage
metal75427383met_al
metals84520883metals
metamer1139613metamer
metate82720533metate
mete64438133met__e
meted85424433met_ed
meteor84910073meteor
metepa1066013metepa
meter75130323met_er
meters85625833meters
metes74736213met_es
meth95827843met__h
method1239023method
meths105320233met_hs
methyl1436403methyl
metier83517693metier
meting94320593meting
metis75025903met_is
metol75917813met_ol
metols84115773metols
metope10611123metope
metre74821303met_re
metred95315143metred
metres85121563metres
metric10314673metric
metro74718803met_ro
metros84217803metros
mettle83815723mettle
mezuza1643533mezuza
mixup1636773mixu_p
mugwump1741213mugwump
mum76643613m__um_
mumm75718863m__umm
mumps115619103m__umps
mums85732773m__ums
mumu86022063m__umu
mutual838503mutual
mutuel837823mutuel
mutule8311423mutule
netop7312343net_op
neum66723083ne_um_
neume74414403ne_ume
neums75414253ne_ums
notum7611683notum_
omentum1155933omentum_
omentums1243973omentums
outjump1843773outjump
petnap1037423petnap
plump115315263_plump
pump105726853__pump
rectum103411283rectum_
rectums11338523rectums
relume8313273relume
repumps1334403repumps
restamp1146483restamp
resume8313783resume
retem74221953retem_
retems83914573retems
retime85321803retime
retune69121953retune
return623222523return
retuse66617223retuse
revamp1336013revamp
rump86729083__rump
sebum93814553sebum_
sebums10369813sebums
sedum84115573sedum_
sedums93910483sedums
septum1037993septum_
septums1135743septums
serum75223473serum_
serums83916303serums
setups83910463setups
shlump1345713shlump
situp74414063situ_p
slump94816633_slump
stamp95217363_stamp
stomp95616663_stomp
stum65526013_stum_
stumps104912283_stumps
stumpy13458133_stumpy
stums75320083_stums
sump86331533__sump
tamp86133003__tamp
tectum10328603tectum_
tectums11306423tectums
temp85323333__temp
thump126211573_thump
trump95615123_trump
tumps95420793__tumps
tup56037543__tu_p
ump76130443___ump
velum10713383velum_
whump154910043_whump

Search took 5 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161684.78323566.0
3Display Results1681680.0463652.2
 (SQL Overall)1786911684.96935961.2
 
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.