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

202 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
rubric109782(None) 
lubric1097981lubric
rubrics1177091rubrics
auric74521732au_ric
cubic114313422cub_ic
cupric1249122cupric
fabric1337832fabric
hubris11218972hubris
pubic114513722pub_ic
public12238142public
rabic93817402rab_ic
rubidic1264542rubidic
rubrical1296092rubrical
runic73615772ru_nic
rustic8712672rustic
suberic11312212suberic
uric63624942_u_ric
abri65522213_abri_
abris75722603_abris
abulic106411423abulic
agaric93513633agaric
anuric8812103anuric
arabic10312733arab_ic
aulic74420243au_lic
auris55331533au_ris
baric96125693_baric
boric98024223_boric
brick134618153__brick
brie65837903__brie
brig76528033__brig
brim85629373__brim
brin67038193__brin
brio65432493__brio
bris65539613__bris
brit66350153__brit
bubonic1366243bubonic
burin75626063bu_rin
bustic101012693bustic
butyric1445123butyric
cambric1537383cambric
capric12411803capric
cerebric1444633cerebric
ceric94023093_ceric
choric133515903choric
citric102812313citric
cleric10612133cleric
cubics123810163cub_ics
cubit94122893cub_it
cuboid1139503cuboid
cultic105111903cultic
curia74523773cu_ria
curie74533043cu_rie
curio74221213cu_rio
currie84317263currie
daric85623113_daric
debris93311493debris
druidic1143523druidic
dubbin11329263dubbin
duroc84513143du_roc
durrie73713263durrie
fabrics1436093fabrics
ferric1139993ferric
fibril1137163fibril
fibrin1138533fibrin
flueric1246143flueric
fluoric1245813fluoric
fumaric1446303fumaric
fundic12389083fundic
fungic12387813fungic
fustic11910633fustic
huic94818053hu__ic
humic124113243hu_mic
hybrid15237813hybrid
hybris14247003hybris
hydric15227953hydric
iatric8312163iatric
krubi1136523krub_i_
krubis1235003krub_is
kukri835043kukri_
kukris934453kukris
libri74610113libri_
lubrical12116093lubrical
ludic82912803lu_dic
luetic8310383luetic
lurid64618973lu_rid
lyric104512723_lyric
metric10314673metric
muonic10410183muonic
murid84520583mu_rid
music94316403mu_sic
naric76824173_naric
nitric82512063nitric
nubbin10308293nubbin
nubia7311233nub_ia
numeric1158193numeric
nutria639913nutria
ourie54027303ou_rie
outrig72812853outrig
picric12309923picric
prussic1144743prussic
pubis94616473pub_is
publics13207143publics
pudic104614563pu_dic
puri65931443pu_ri_
purin75527593pu_rin
puris75332023pu_ris
putrid9311173putrid
pyric123815073_pyric
quadric1946313quadric
quartic18258473quartic
qubit164218993qub_it
quinic17319473quinic
rabbi93113183rabbi_
rabbin103112303rabbin
rabbis102613163rabbis
rabbit102914563rabbit
rabid84520783rab_id
rebait8320403rebait
rebec94416543reb_ec
rebid85121363reb_id
reboil83814683reboil
rebred95816353rebred
redbrick1742653redbrick
relic74623363r_elic
reprice113212833reprice
republic1442983republic
rerig64018483r_erig
retrim83514883retrim
rhodic12227233rhodic
rhotic112711233rhotic
ricrac1037013ricrac
robbin103611183robbin
robin74820283rob_in
robotic1139223robotic
rub56342823rub___
rubace10310173rubace
rubati8299693rubati
rubato8319683rubato
rubbed114515083rubbed
rubber104715793rubber
rubbies114114113rubbies
rubbing123412273rubbing
rubbish1436303rubbish
rubble104315673rubble
rubbly133710613rubbly
rubby124413863rub_by
rube65532013rub__e
rubel75416833rub_el
rubels84112993rubels
rubes74928413rub_es
rubied94312413rubied
rubier84814743rubier
rubies84420343rubies
rubigo935053rubigo
ruble74521253rub_le
rubles83921703rubles
ruboff1435203ruboff
rubout8313563rubout
rubricate1346483rubricate
rubrician1353833rubrician
rubs66133493rub__s
rubus76415063rub_us
ruby97819943rub__y
rubying13297933rubying
ruer46127563ruer__
ruers515019413ruer_s
ruin47430513ru__in
rural55821173ru_ral
rurban849043rurban
rustics9810733rustics
rutin55421343ru_tin
sorbic10310393sorbic
steric8317063steric
subarid10310653subarid
suberin9314563suberin
subfix1835073subfix
submit10312673submit
subrace11313003subrace
subring104116263subring
terbic10410963terbic
thoric114314043thoric
toric76529313_toric
tugrik1134283tugrik
tumbril11256403tumbril
tunic74018223tu_nic
turbid979713turbid
turbit8715113turbit
unrig61711413_unrig
unrip72012863_unrip
uranic82315183uranic
urari54619963urari_
uraris63817273uraris
uratic83016353uratic
urbia7311143urb_ia
ureic74514463_ureic
uremic103410513uremic
uretic82914353uretic
vibrio1136223vibrio
vitric112510113vitric
xeric144315663_xeric
yttric1145433yttric
zebraic2044293zebraic

Search took 6 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.470380193.6
2DLD Change Limit1127162025.12621989.1
3Display Results2022020.0603366.7
 (SQL Overall)1786912025.65631593.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.