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

207 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
fabrics143609(None) 
fabric1337831fabric_
abris75722602_abri_s
cambrics1645252cambrics
darics94314112da_rics
faeries104118992faeries
fairies103516042fairies
fanfics1535172fanfics
fibrils1236842fibrils
fibrins1238642fibrins
rubrics1177092rubrics
ablins8316193_ablins
abri65522213_abri__
aeries64737783_aeries
afrits9311903_afrits
agarics10319943agarics
agrias74315393_agrias
ambries111614553ambries
antics84621453_antics
arcs67834783_a_r_cs
arias55438023_a_rias
arils58732203_a_rils
arris56824683_arri_s
asdics9439863_asdics
aspics104211563_aspics
attics84413283_attics
auric74521743_auric_
auris55331533_auri_s
babies106123653bab_ies
baldrics13164893baldrics
barbies114519593barbies
baric96125693ba_ric_
barrios9310773barrios
basics104915123ba_sics
bawdrics16153273bawdrics
brick134618153__brick
bricks144614623__bricks
bries74942153__bries
brigs85823223__brigs
brims94721623__brims
brins75533973__brins
brios74725723__brios
bris65539613__bri_s
briss75824273__briss
brits76433083__brits
cabbies133115163cabbies
cabins104418923cab_ins
calorics122810463calorics
cambric1537393cambric_
capric12411803capric_
caprice1349683caprice
caprices1439893caprices
capris10415083capri_s
carices114220953ca_rices
caries85147623ca_ries
carries94328013carries
clerics1149333clerics
cubics123810163cub_ics
dairies84217733dairies
darbies104216983darbies
daric85623123da_ric_
daubries1136743daubries
debris93311493debri_s
fablers124812613fablers
fables114921673fab_les
fabliau1244903fabliau
fabling133413623fabling
fabricant1644893fabricant
fabricants1743023fabricants
fabricate1646833fabricate
fabricates1746473fabricates
fabs98635863fab___s
facias113415803fa_cias
facies113921593fa_cies
fadeins1168503fadeins
faerie93514683faeri_e
fagins10513863fa_gins
fails85631483fa__ils
fairing113614013fairing
fairings12388193fairings
fairish1338993fairish
fairs85825443fa__irs
fakeries1559833fakeries
fakirs13468083fa_kirs
falsies103515013falsies
fanatics1367183fanatics
fancies124018783fancies
fanfic1436313fanfic_
fannies103415643fannies
faqirs18456033fa_qirs
faquirs1943863faquirs
farads104713273fa_rads
farce104925323fa_r_ce
farces115223323fa_rces
farci105919313fa_r_ci
farcie114816473fa_rcie
farcies125317883farcies
farcy135217093fa_r_cy
fards96629843fa_r_ds
farers95924053fa_rers
fares85852873fa_r_es
farina94618233fa_rina
farinas103215253fa_rinas
faring105231283fa_ring
farles96025783fa_rles
farls85731113fa_r_ls
farms106324953fa_r_ms
faros85532023fa_r_os
farrier103514893farrier
farriers113610743farriers
farrows13259793farrows
farts88336843fa_r_ts
fascias1258413fascias
fatbirds1443413fatbirds
fatties103018203fatties
febrile1237153febrile
ferias95020393f_erias
ferric1139993ferric_
ferries103521083ferries
fibres114312123fibr_es
fibril1137163fibri_l
fibrin1138533fibri_n
fibroids1445853fibroids
fibroins1346223fibroins
fibrous1237593fibrous
flics105418363f__lics
florins10311643florins
fluerics1345393fluerics
forbids13268263forbids
fries85535603f__ries
frigs96019273f__rigs
frits86129103f__rits
frolics1236833frolics
furies95126373f_uries
fustics1279593fustics
gabies93820733gab_ies
garlics1038013garlics
habits113014653hab_its
harries103525503harries
hayrick1944183hayrick
hayricks2043763hayricks
hubris11218973hubri_s
hybrids16236023hybrids
hybris14247003hybri_s
iambics13425643iambics
iatric8312173iatric_
jabirus1694573jabirus
kauries113613193kauries
kauris103611533kauri_s
labrets939363labrets
labroids1155843labroids
labrums1175853labrums
laics76419253la__ics
laris54737463la_ri_s
latrias71913213latrias
lubric1097983lubric_
lyrics11357943_lyrics
magics115311613ma_gics
manics103919933ma_nics
marcs95726623ma_r_cs
marries93825283marries
mastics112614783mastics
matrices12312083matrices
metrics11312363metrics
nabis76020583nab_i_s
narcs76122023na_r_cs
naric76824173na_ric_
naris55735293na_ri_s
panics103815363pa_nics
paprica1337003paprica
papricas1447053papricas
paries84742523pa_ries
paris75145943pa_ri_s
parries93925853parries
publics13207143publics
quadrics2045653quadrics
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabbi_s
rabbits11299863rabbits
rabic93817403rab_ic_
rabies85226023rab_ies
rubric1097823rubric_
sabins85521983sab_ins
sabirs85414633sab_irs
sabras85116363sabr_as
sabres85520863sabr_es
sabring102614843sabring
sarins63932623sa_rins
saris54544953sa_ri_s
sauries72821623sauries
sferics1236133sferics
tabbies112913503tabbies
tabbis102910863tabbi_s
tabetics1245683tabetics
taborins103310223taborins
tactics1149323tactics
tanrecs934823tanrecs
tarocs84615663ta_rocs
tarries73324263tarries
torics85118353_torics
varias95019903va_rias
varices123313573va_rices
varies94330873va_ries
vibrios1235803vibrios
vitrics12198553vitrics
yabbies14279643yabbies

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272076.65620136.3
3Display Results2072070.0633285.7
 (SQL Overall)1786912077.12525079.4
 
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.