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

201 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
regnum95716(None) 
begum105213922beg_um
degum94711902deg_um
frenum1188802fre_num
magnum1136732magnum
rectum103411282rectum
regius7311922regius
reglue739702reglue
regna64614812regn_a
regnal74812932regnal
aecium10410423aecium
agendum1144673agendum
algum82711763alg_um
arcanum1176443arcanum
argentum1145363argentum
begrim11118333begrim
begums11429493beg_ums
begun85113443beg_un
benumb1235773be_numb
cecum11611843ce_cum
centum104012363centum
cerium10313773cerium
cesium1039583cesium
crinum1039333crinum
degerm1037893degerm
degums10438623deg_ums
dengue838253dengue
denim85518843de_nim
ennui537523_ennui
enuf7323843_e_nuf
erbium1038083erbium
fanum10313443_fanum
ferrum1147453ferrum
fraenum1255703fraenum
frenums1236203fre_nums
gaum75726423__gaum
genom83716843ge_nom
genu55929073ge_nu_
genua64614153ge_nua
genus65319833ge_nus
geum75424553__geum
glum75825103__glum
gnu45522043__gnu_
gnus56518003__gnus
granum9310913granum
grum75625083__grum
gum67439533__g_um
helium112311253helium
hognut1039413hognut
jejunum1542083jejunum
jugum15167473jug_um
legume936913leg_ume
linum7313823_linum
magnums1234683magnums
medium113711623medium
megohm14124193megohm
megrim1178043megrim
mentum104511713mentum
menu65130233me_nu_
menus75822843me_nus
negus64513563neg_us
neum66723083ne__um
organum1045343organum
origanum1143393origanum
peanut8318183peanut
peplum12156823peplum
pignus937953pignus
pignut9311573pignut
plenum1039503plenum
premium13310363premium
radium93513293radium
ragout7317183ragout
realm75621623re_alm
ream65841613re__am
rearm75923573re_arm
rebus75721113re_bus
rebut75927383re_but
rebuy104714683re_buy
recoup10810373recoup
rectums11338523rectums
rectus83314633rectus
recur74116843re_cur
recut74729243re_cut
redbud10135803redbud
redbug10165473redbug
redeem9311533redeem
redout71820253redout
redub84212413re_dub
redux133811103re_dux
refilm114311403refilm
reflux16315413reflux
reform11312713reform
refugium1443063refugium
refund104810303refund
reg46146493reg___
regain74517763regain
regal65023793reg_al
regale74821453regale
regard85215773regard
regauge945813regauge
regave104713383regave
regear73512743regear
regency1337363regency
regent74127673regent
regents83416543regents
reges65628793reg_es
reggae858953reggae
regild8149773regild
regilt71217493regilt
regime95313943regime
regina75317143regina
reginae84713453reginae
reginal84814293reginal
reginas85614063reginas
region74614903region
regive104814323regive
reglet73724233reglet
reglow10339403reglow
reglued936333reglued
reglues838713reglues
regma84612333reg_ma
regnant8312843regnant
regret73723533regret
regrew10388563regrew
regroom1077303regroom
regroup1095173regroup
regrow10309883regrow
regs55436573reg__s
reguli738143reguli
regulus836523regulus
rehem103815353re_hem
rehung1036343rehung
reign65015193reign__
reigned949213reigned
reigns74811753reign_s
rein46040893rein__
reincur945133reincur
reined74425523reined
reink95518093rein_k
reinks105012153reinks
reins56234563rein_s
reknit10312533reknit
reknot10311733reknot
relume8313273re_lume
rem56150043re___m
renal55929513re_nal
rename82718813re_name
rend56136573re_n_d
rends65129953re_nds
renew83917513re_new
renig64518913re_nig
renin54830033re_nin
rennet64624853rennet
rennin63914033rennin
rent46661243re_n_t
rente54733783re_nte
rents55935183re_nts
replumb1343393replumb
repour8310993repour
repump1235683re_pump
rerun58722153re_run
reruns66413743reruns
rescue8313003rescue
resume8313783re_sume
reteam83214533reteam
retem74221953re_tem
retinue75414843retinue
retrim83514883retrim
retune69121953retune
revenue1039533revenue
revue81114453re_vue
rewarm115913493rewarm
rhenium1246243rhenium
rheum1038843r_heum
rigour7258023rigour
rogue66417533rog_ue
rugous739653rugous
rum56644643r___um
sagum8512873sag_um
sebum93814553se_bum
sedum84115573se_dum
segni63712483segn_i
segno64814743segn_o
segnos73610443segnos
segue6314413seg_ue
sensum849353sensum
septum1038003septum
serum75223473se_rum
siglum936563siglum
sternum947733sternum
tectum10328603tectum
tedium9269873tedium
tegua6109563teg_ua
telium82611393telium
tergum937933tergum
uredium1076693uredium
vellum1136773vellum
velum10713383ve_lum
venom103914863ve_nom
venue84918213ve_nue
venus84918903ve_nus

Search took 7 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.390458182.1
2DLD Change Limit1127162016.03018692.5
3Display Results2012010.0633190.5
 (SQL Overall)1786912016.48327563.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.