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

284 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
fabric133783(None) 
fabrics1436091fabrics
abri65522212_abri_
abris75722602_abris
auric74521742_auric
baric96125692ba_ric
cambric1537392cambric
capric12411802capric
daric85623122da_ric
faerie93514682faerie
fanfic1436312fanfic
farci105919312fa_rci
ferric1139992ferric
fibril1137162fibril
fibrin1138532fibrin
iatric8312172iatric
lubric1097982lubric
naric76824172na_ric
rabic93817402rab_ic
rubric1097822rubric
abaci94718843_abaci
aboil72217543_aboil
abulic106411423_abulic
acmic11312333_acmic
acrid86920103_acrid
aerie54634603_aerie
afrit8323173_afrit
agaric93513643agaric
agria65517143_agria
amnic95516243_amnic
antic75728863_antic
anuric8812113anuric
aortic8316613_aortic
arabic10312733arab_ic
arc510250903_a_r_c
areic73219393_areic
aria46245423_a_ria
arid57642713_a_rid
aril45843023_a_ril
arris56824683_arris
asdic83814093_asdic
aspic95114733_aspic
atria56022343_atria
atrip75315753_atrip
attic75618353_attic
aulic74420243_aulic
auris55331533_auris
azoic162912063_azoic
baldric12166403baldric
barbaric1446373barbaric
barbie105018353barbie
bardic11312923bardic
barrio8312573barrio
basic96220523ba_sic
bawdric15164583bawdric
boric98024223_boric
brick134618153__brick
brie65837903__brie
brig76528033__brig
brim85629373__brim
brin67038193__brin
brio65432493__brio
bris65539613__bris
brit66350153__brit
cabbie122913353cabbie
cabin94820943cab_in
cadmic1338983cadmic
calcic9311873calcic
caloric113413223caloric
cambrics1645253cambrics
cantic103920543cantic
caprice1349683caprice
capris10415083capris
caseic103212373caseic
ceric94023093_ceric
choric133515903choric
citric102812313citric
cleric10612133cleric
cubic114313423cub_ic
cupric1249123cupric
darics94314113da_rics
daturic1047033daturic
debris93311493debris
fab87453133fab___
fabber134814113fabber
fable105824753fab_le
fabled124216383fabled
fabler116115813fabler
fables114921673fables
fabliau1244903fabliau
fabling133413623fabling
fabricant1644893fabricant
fabricate1646833fabricate
fabs98635863fab__s
facia103218463fa_cia
fadein1068843fadein
faeries104118993faeries
faery116015483faer_y
fagin9216573fa_gin
fail74840243fa__il
fain75840563fa__in
fair76332523fa__ir
faired105915773faired
fairer95212063fairer
fairies103516043fairies
fairing113614013fairing
fairish1338993fairish
fairly125610013fairly
fairs85825443fair_s
fairy115318283fair_y
fakir125111493fa_kir
fakirs13468083fakirs
falsie93513853falsie
fanatic12610703fanatic
fanfics1535173fanfics
faqir17548643fa_qir
faqirs18456033faqirs
faquir1834313faquir
far67762603fa_r__
farad95720673fa_rad
faradic1337693faradic
farce104925323fa_rce
farcie114816473farcie
farcy135217093fa_rcy
fard85639063fa_r_d
fards96629843fa_rds
fare76354463fa_r_e
fared95842343fa_red
farer86733143fa_rer
fares85852873fa_res
farina94618233fa_rina
faring105231283fa_ring
farl76338553fa_r_l
farle86929243fa_rle
farls85731113fa_rls
farm95934533fa_r_m
farms106324953fa_rms
faro76136923fa_r_o
faros85532023fa_ros
farrier103514893farrier
farrow12309973farrow
fart76860563fa_r_t
farts88336843fa_rts
fascia1148703fascia
fatbird1344033fatbird
fatidic1345723fatidic
febrific1842713febrific
febrile1237153febrile
feirie939553feirie
felsic1147053felsic
feria85922713f_eria
fibre104812843fibr_e
fibres114312123fibres
fibrils1236843fibrils
fibrins1238633fibrins
fibroid1337243fibroid
fibroin1246473fibroin
fibrotic1545723fibrotic
filmic13348453filmic
fimbria1444453fimbria
fistic11812573fistic
fjordic2042383fjordic
flic96223733f__lic
florid10311453florid
florin9312653florin
flueric1246143flueric
fluoric1245813fluoric
folic105319323f_olic
forbid123312433forbid
formic13310453formic
forrit91916623forrit
frantic12310373frantic
frig85424503f__rig
frit77044473f__rit
friz166324343f__riz
frolic1149203frolic
fumaric1446313fumaric
fundic12389083fundic
fungic12387813fungic
fustic11910633fustic
gabbroic1541993gabbroic
gallic9411643gallic
gamic103916203ga_mic
garlic9310043garlic
gastric1038643gastric
habit103027023hab_it
haemic133210083haemic
haptic13511893haptic
hayrick1944183hayrick
hubris11218973hubris
hybrid15237813hybrid
hybris14247003hybris
hydric15227953hydric
iambic12468283iambic
jabiru15125513jabiru
kaonic1238763kaonic
karmic1438113karmic
kauri93811853kauri_
kauris103611533kauris
laari54415713laari_
labia75219013lab_ia
labra75415463labr_a
labret8320223labret
labroid1038823labroid
labrum1057423labrum
lactic10713493lactic
laic65931563la__ic
lari45839153la_ri_
laris54737463la_ris
latria62313603latria
libri74610113libri_
lyric104512723_lyric
mafic125615463ma_fic
magic105818663ma_gic
malic94525663ma_lic
manic94629443ma_nic
mantic104120903mantic
mantric11311353mantric
marc87034633ma_r_c
maria75032883ma_ria
mastic103119173mastic
matrix1539853matrix
metric10314683metric
nabis76020583nab_is
narc67127953na_r_c
naris55735293na_ris
nastic82915973nastic
nitric82512063nitric
padri85815173padri_
panic93923903pa_nic
paprica1337003paprica
paris75145943pa_ris
picric12309923picric
pubic114513723pub_ic
public12238143public
pyric123815073_pyric
quadric1946313quadric
rabbi93113183rabbi_
rabbin103112303rabbin
rabbis102613163rabbis
rabbit102914563rabbit
rabid84520783rab_id
rubrics1177093rubrics
sabin74924953sab_in
sabir75917003sab_ir
sabirs85414633sabirs
sabra75317853sabr_a
sabras85116363sabras
sabre74821503sabr_e
sabred95916533sabred
sabres85520863sabres
sabring102614843sabring
salic73424713sa_lic
sari45444043sa_ri_
sarin55239253sa_rin
saris54544953sa_ris
satiric939253satiric
satyric1237503satyric
sorbic10310393sorbic
steric8317063steric
suberic11312213suberic
tabbis102910863tabbis
tabetic1138463tabetic
tabid84418263tab_id
taborin92210453taborin
tactic10612753tactic
tannic82811473tannic
tanrec837803tanrec
tantric939593tantric
taroc75721643ta_roc
terbic10410963terbic
thoric114314043thoric
toric76529313_toric
uric63624943__uric
valeric1238303valeric
varia85824203va_ria
varix154313513va_rix
vatic10316423va_tic
vibrio1136223vibrio
vitric112510113vitric
xeric144315663_xeric
yabbie13308663yabbie
yttric1145433yttric
zebraic2044293zebraic

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.420425454.8
2DLD Change Limit1127162845.90619085.0
3Display Results2842840.0933053.8
 (SQL Overall)1786912846.41927837.8
 
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.