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

181 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
fibrils123684(None) 
fibril1137161fibril_
fibrins1238641fibrins
fabrics1436092fabrics
febrile1237152febrile
fibres114312122fibr_es
fibrilla1364372fibrilla
fibrin1138532fibri_n
fibroids1445852fibroids
fibroins1346222fibroins
fibrous1237592fibrous
fierily1339022fierily
nitrils72810702nitrils
vibrios1235802vibrios
abris75722603_abri_s
afebrile1342683afebrile
aiblins9311473aiblins
airily93014823ai_rily
ambries111614553ambries
arils58732203__arils
bails75933523__bails
birls74023163bi_r_ls
boils75427193__boils
brails84621293__brails
bries74942153__bries
brigs85823223__brigs
brill74819953__brill
brills84916293__brills
brims94721623__brims
brins75533973__brins
brios74725723__brios
bris65539613__bri_s
briss75824273__briss
brits76433083__brits
broils84114173__broils
cibols1039523cib_ols
citrals91111673citrals
citrins92614363citrins
debris93311493debri_s
diaries83321953diaries
dirls64720503di_r_ls
distils83015803distils
embroils1245773embroils
fabric1337833fabri_c
faeries104118993faeries
fails85631483f__ails
fairies103516043fairies
farls85731113f_ar_ls
ferals94216643f_erals
ferias95020393f_erias
ferrels10248623ferrels
ferries103521083ferries
fewtrils1443203fewtrils
fiars86720833fiar__s
fibbers144510603fibbers
fibbing15339463fibbing
fiberfill1751753fiberfill
fiberfills1851733fiberfills
fiberize2246143fiberize
fiberizes2346183fiberizes
fibers114717523fib_ers
fibre104812843fibr__e
fibrefill1751693fibrefill
fibrefills1851673fibrefills
fibrillae1463473fibrillae
fibrillar1463343fibrillar
fibrinous1443853fibrinous
fibroid1337253fibroid
fibroin1246473fibroin
fibroma1444123fibroma
fibromas1544403fibromas
fibroses1345983fibroses
fibrosis1345463fibrosis
fibs96329513fib___s
fibula11258053fib_ula
fibulas12228563fibulas
ficins113513983fi_cins
fictile1238023fictile
fierier103511193fierier
fieriest112112243fieriest
fifties132111083fifties
fillies103420253fillies
fillips12298133fillips
fills84632373fi__lls
filmily1535733filmily
filmis114610283filmi_s
fils75838703f___ils
fimbria1444453fimbri_a
fimbriae1543773fimbriae
fimbrial1544193fimbrial
finalis103313663finalis
finals94316163fi_nals
fineries112416753fineries
finials103210153finials
finis86824263fi_ni_s
fiords10498623fior_ds
firers94922683fi_rers
fires85740753fi_r_es
firing104021723fi_ring
firings114112333fi_rings
firkins1437663firkins
firmly1436663fi_rmly
firms105217423fi_r_ms
firns86018543fi_r_ns
firrier103410133firrier
firriest112310433firriest
firs76637723fi_r__s
firsts95110923fi_rsts
firths125113503fi_rths
fiscals1238003fiscals
fishily1637643fishily
fissile10269653fissile
fizgigs2142203fizgigs
flails94313003f_lails
florals104210063florals
florins10311643florins
foils85025813f__oils
forbids13268263forbids
fossils10379013fossils
frails93716473f_rails
frazils1956123frazils
friaries11310083friaries
fries85535603f__ries
frigs96019273f__rigs
frill84917563f__rill
frills94414223f__rills
frits86129103f__rits
fulfils1345723fulfils
furies95126373f_uries
furls85322053f_ur_ls
furrily1337613furrily
fusils93912343f_usils
fuzils18407963f_uzils
gerbils1037303gerbils
girls64518393gi_r_ls
hubris11218973hubri_s
hybrids16236023hybrids
hybris14247003hybri_s
ibis66519583_ib_i_s
irids66417783_i_rids
iris45732553_i_ri_s
kibbis14398473kibbi_s
kibeis12469803kibei_s
libels85112693lib_els
liberals1039413liberals
libras83711703libr_as
libri74610113libri__
midribs1235513midribs
mirins83918903mi_rins
myofibrils2051073myofibrils
nihils937573ni_hils
nitrids8269633nitrids
nitril62511533nitril_
nitrile73011373nitrile
nitriles8269923nitriles
nombrils1244513nombrils
perils84121853_perils
pibals103813083pib_als
pistils93314303pistils
reboils94111723reboils
ridgils9326573ridgils
rubrics1177093rubrics
sibyls1135303sib_yls
sigils73912363si_gils
tibias839953tib_ias
timbrels12265343timbrels
tirls54519803ti_r_ls
tumbrils12255373tumbrils
twibils1253113twib_ils
upboils1184703upboils
vibrio1136223vibri_o
vibrion1245253vibrion
vibrions1345093vibrions
vibrissa1362223vibrissa
vigils104210193vi_gils
virile9313433vi_rile
virls85618603vi_r_ls
vitrics12198553vitrics
vitriols1145053vitriols
wirily123310783wi_rily
zorils153810883_zorils

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271815.90622693.4
3Display Results1811810.0632873.0
 (SQL Overall)1786911816.37528030.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.