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

149 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
arum6612903(None) 
alum65227611alum
arm58449621ar_m
arums75517831arums
aurum7614961aurum
drum76521591drum
grum75625081grum
larum74317971larum
rum56644641_rum
abut66834952abut
ague55725922ague
ahem97225362ahem
aim57858212a_im
alarum85411982alarum
album92312652album
algum82711762algum
alums75720602alums
am411875562a__m
amu58237322amu_
amus65529612amus
antrum8611312antrum
anus47131112anus
aqua132813962aqua
ar211379382ar__
arak86929572arak
arame75026622arame
arb510448422ar_b
arbs66834732arbs
arc510250902ar_c
arch98628442arch
arco68331542arco
arcs67834782arcs
arcus76918862arcus
are37874572ar_e
area45843392area
ares45871022ares
arf67453372ar_f
arfs76029962arfs
argue64818442argue
argus66716542argus
aria46245422aria
arid57642712arid
aril45843022aril
ark77044962ar_k
arks85936872arks
arms66137492arms
army96624182army
aroma71220142aroma
ars37670932ar_s
arse46539272arse
art38679142ar_t
arts49650262arts
arty77531312arty
arvo76023432arvo
aryl75922342aryl
asarum84610912asarum
atom67824522atom
atrium8411832atrium
auk76234142a_uk
aura45836252aura
aurums849382aurums
barium10313522barium
barm86739602bar_m
brim85629372brim
brume95817982brume
brut66537962brut
brux136315272brux
bum75342692_bum
carom95025562carom
chum116318002chum
cram85635492cram
cru57129562cru_
crud75219612crud
crumb114313592crumb
crump115616422crump
crus65828482crus
crux135415002crux
cum76440162_cum
datum8310632datum
doum76226672doum
dram75832002dram
drub75920132drub
drug65718132drug
drums85415872drums
durum8513202durum
fanum10313442fanum
farm95934532far_m
forum108318762forum
from96923922from
frug86517102frug
frump126912562frump
gaum75726422gaum
geum75424552geum
glum75825102glum
gram77034582gram
grim76929422grim
grub77220082grub
grue55825712grue
grume86218162grume
grump105115312grump
gum67439532_gum
harem104924452harem
harm95637792har_m
hum85542932_hum
jorum145513742jorum
labrum1057422labrum
larums83610532larums
lum55542932_lum
mum76643612_mum
neum66723082neum
oakum1177312oakum
ovum92310172ovum
plum85122102plum
pram85733492pram
prim85132202prim
prom87631702prom
ram56867272_ram
rem56150042_rem
rim56052272_rim
rom59855632_rom
rub56342822_rub
rue35549262_rue
rug46039152_rug
rump86729082_rump
rums64833472_rums
run36244992_run
rut35560522_rut
sacrum103910142sacrum
sagum8512872sagum
scrum95418202scrum
scum85924522scum
serum75223472serum
slum65430512slum
strum75619452strum
stum65526022stum
sum56346012_sum
swum96416822swum
thrum104713632thrum
tram67034552tram
trim65329522trim
true46725852true
trug55720042trug
trump95615122trump
um47338832__um
urus46426142urus
varus85921182varus
vum85428652_vum
warm95935672war_m
yum86132822_yum

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298721490.90632971.3
3Display Results1491490.0334515.2
 (SQL Overall)1786911491.219146588.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.