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

192 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
lubric109798(None) 
rubric1097821rubric
auric74521742au_ric
cubic114313422cub_ic
cupric1249122cupric
fabric1337832fabric
flueric1246142flueric
fluoric1245812fluoric
hubris11218972hubris
libri74610112libri_
lubrical12116092lubrical
ludic82912802lu_dic
luetic8310382luetic
lurid64618972lu_rid
lyric104512722l_yric
pubic114513722pub_ic
public12238142public
rubrics1177092rubrics
suberic11312212suberic
uric63624942_u_ric
abri65522213_abri_
abris75722603_abris
abulic106411423abulic
agaric93513643agaric
anuric8812113anuric
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
cambric1537393cambric
capric12411803capric
ceric94023093_ceric
choric133515903choric
citric102812313citric
cleric10612133cleric
colubrid1344413colubrid
cubics123810163cub_ics
cubit94122893cub_it
cuboid1139503cuboid
cultic105111903cultic
curia74523773cu_ria
curie74533043cu_rie
curio74221213cu_rio
currie84317263currie
daric85623123_daric
debris93311493debris
dubbin11329263dubbin
duroc84513143du_roc
durrie73713263durrie
fabrics1436093fabrics
ferric1139993ferric
fibril1137163fibril
fibrin1138533fibrin
fluerics1345393fluerics
fluidic1344383fluidic
fluorid1136783fluorid
fluorin1037233fluorin
fumaric1446313fumaric
fundic12389083fundic
fungic12387813fungic
fustic11910633fustic
huic94818053hu__ic
humic124113243hu_mic
hybrid15237813hybrid
hybris14247003hybris
hydric15227953hydric
iatric8312173iatric
kukri835043kukri_
kukris934453kukris
laari54415713laari_
labia75219013lab_ia
labra75415463labr_a
labret8320223labret
labroid1038823labroid
labrum1057423labrum
lactic10713493lactic
laic65931563l__aic
lari45839153l_ari_
laris54737463l_aris
latria62313603latria
lentic83515743lentic
libra74712423libr_a
librae84310173librae
libras83711703libras
limbic12528743limbic
limnic10418843limnic
liri45128253l_iri_
lithic1139493lithic
logic88217833l_ogic
lorica8310443l_orica
loris55329153l_oris
lotic76420673l_otic
lubber104214623lubber
lube64731563lub__e
lubed85319893lub_ed
lubes74727993lub_es
lubing94114043lubing
lubricant1344523lubricant
lubricate1346443lubricate
lubricity1644363lubricity
lubricous1343953lubricous
lucid84314573lu_cid
luckie123611413luckie
lucre76415523lucr_e
lucres84513303lucres
luetics937323luetics
luggie8318903luggie
lumbrical15113383lumbrical
lunatic938753lunatic
lungi65516053lungi_
lungis77113023lungis
lupin75215843lu_pin
lurch104814633lu_rch
lure45142463lu_r_e
lured65427493lu_red
lurer54625313lu_rer
lures56138533lu_res
lurex124816733lu_rex
luring73820753lu_ring
lurk86624163lu_r_k
lurks95218743lu_rks
lutein6311263lutein
lyrics11357943l_yrics
lytic104513033l_ytic
metric10314683metric
muonic10410183muonic
murid84520583mu_rid
music94316403mu_sic
naric76824173_naric
nitric82512063nitric
nubbin10308293nubbin
nubia7311233nub_ia
numeric1158193numeric
nutria639913nutria
ourie54027303ou_rie
outrig72812853outrig
picric12309923picric
plumbic1543963plumbic
pubis94616473pub_is
publics13207143publics
pudic104614563pu_dic
puri65931443pu_ri_
purin75527593pu_rin
puris75332023pu_ris
putrid9311173putrid
pyric123815073_pyric
quadric1946313quadric
quartic18258473quartic
qubit164218993qub_it
quinic17319473quinic
rabic93817403rab_ic
rubidic1264543rubidic
rubrical1296093rubrical
runic73615773ru_nic
rustic8712673rustic
sorbic10310393sorbic
steric8317063steric
subarid10310653subarid
suberin9314563suberin
subfix1835073subfix
submit10312673submit
subrace11313003subrace
subring104116263subring
terbic10410963terbic
thoric114314043thoric
toric76529313_toric
tugrik1134283tugrik
tumbril11256403tumbril
tunic74018223tu_nic
turbid979713turbid
turbit8715113turbit
unrig61711413_unrig
unrip72012863_unrip
urbia7311143_urbia
ureic74514463_ureic
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.376475242.0
2DLD Change Limit1127161925.40620850.2
3Display Results1921920.0603200.0
 (SQL Overall)1786911925.84230587.3
 
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.