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

203 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
fibril113716(None) 
fibrils1236841fibrils
fibrin1138531fibrin
fabric1337832fabric
febrile1237152febrile
fibre104812842fibr_e
fibres114312122fibres
fibrilla1364372fibrilla
fibrins1238632fibrins
fibroid1337242fibroid
fibroin1246472fibroin
fierily1339022fierily
fimbria1444452fimbria
fimbrial1544192fimbrial
libri74610112libri_
nitril62511532nitril
vibrio1136222vibrio
aboil72217543_aboil
abri65522213_abri_
abris75722603_abris
afebrile1342683afebrile
airily93014823ai_rily
aril45843023__aril
bail65042803__bail
birl65830473bi_r_l
boil66335183__boil
brail75525553__brail
brie65837903__brie
brig76528033__brig
brill74819953__brill
brim85629373__brim
brin67038193__brin
brio65432493__brio
bris65539613__bris
brit66350153__brit
broil74918223__broil
cibol9512023cib_ol
ciboria1147043ciboria
cirri7710723cirri_
citral81113893citral
citric102812313citric
citrin82615413citrin
civil103411933ci_vil
debris93311493debris
dirl57430023di_r_l
distil73616433distil
embroil1146613embroil
fabrics1436093fabrics
faerie93514683faerie
fail74840243f__ail
farl76338553f_ar_l
feirie939553feirie
feral85424653f_eral
feria85922713f_eria
ferial94621253f_erial
ferrel92810203ferrel
ferric1139993ferric
fiar76427333fiar__
fiars86720833fiar_s
fib86344273fib___
fibbed144011553fibbed
fibber134811933fibber
fibbing15339463fibbing
fiber104921133fib_er
fibered1337643fibered
fiberfill1751753fiberfill
fiberize2246143fiberize
fibers114717523fibers
fibrefill1751693fibrefill
fibrillae1463473fibrillae
fibrillar1463343fibrillar
fibroids1445843fibroids
fibroins1346213fibroins
fibroma1444123fibroma
fibrosis1345453fibrosis
fibrotic1545723fibrotic
fibrous1237593fibrous
fibs96329503fib__s
fibula11258053fibula
ficin103516723fi_cin
fictile1238023fictile
fierce11348913fierce
fierier103511193fierier
fiery114714793fier_y
figural1145243figural
fil65447143f___il
filaria1039653filaria
filarial1147863filarial
filial93013253filial
fill75540193fi__ll
fillip11268953fillip
filmi105914003filmi_
filmic13348453filmic
filmily1535733filmily
filmis114610283filmis
fimbriae1543773fimbriae
final83922033fi_nal
finial92814183finial
finis86824263fi_nis
fiord94313343fior_d
fiords10498623fiords
fir66744893fi_r__
fire76245593fi_r_e
fired94829743fi_red
firer811229253fi_rer
fires85740753fi_res
firing104021723fi_ring
firkin1337823firkin
firm96026453fi_r_m
firmly1436663fi_rmly
firms105217423fi_rms
firn76927503fi_r_n
firns86018543fi_rns
firrier103410133firrier
firry115713533fi_rry
firs76637713fi_r_s
first86226123fi_rst
firth115819533fi_rth
fiscal1139333fiscal
fishily1637643fishily
fissile10269653fissile
fistic11812573fistic
fitful1256333fitful
fixit154819303fi_xit
fizgig2032973fizgig
flail85316183f_lail
floral94313813floral
florid10311453florid
florin9312653florin
foil76433913f__oil
forbid123312433forbid
forrit91916623forrit
fossil9379353fossil
frail85220213f_rail
frazil1847223frazil
frig85424503f__rig
frill84917563f__rill
frit77044473f__rit
friz166324343f__riz
fulfil1246423fulfil
furl77030883f_ur_l
furrily1337613furrily
fusil84715323f_usil
fuzil173810703f_uzil
gerbil938343gerbil
girl56226553gi_r_l
hubris11218973hubris
hybrid15237813hybrid
hybris14247003hybris
ibis66519583_ib_is
irid55927173_i_rid
iris45732553_i_ris
kibbi13449273kibbi_
kibbis14398473kibbis
kibei114311533kibei_
kibeis12469803kibeis
libel74116103lib_el
liberal9310193liberal
libra74712423libr_a
librae84310173librae
libras83711703libras
liri45128253li_ri_
lubric1097983lubric
midrib1138243midrib
miri66730373mi_ri_
mirin75023153mi_rin
mitral81314323mitral
myofibril1951203myofibril
nihil8410283ni_hil
nitric82512063nitric
nitrid72812233nitrid
nitrile73011373nitrile
nitrils72810703nitrils
nombril1145103nombril
peril75425953_peril
pibal95217323pib_al
picric12309923picric
pistil83915073pistil
reboil83814683reboil
ridgil8316823ridgil
rubric1097823rubric
sibyl1037113sib_yl
sigil63515503si_gil
tibia7312403tib_ia
tibial849843tibial
timbral11237193timbral
timbrel11306563timbrel
tirl45029923ti_r_l
tumbril11256403tumbril
twibil1133563twib_il
umbral1038633umbral
upboil1096453upboil
vibrion1245253vibrion
vibrios1235803vibrios
vigil94313003vi_gil
viral86419593vi_ral
virid94116043vi_rid
virile9313433vi_rile
virl76224473vi_r_l
vitric112510113vitric
vitriol1045693vitriol
wirily123310783wi_rily
zoril143916693_zoril

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.393454684.5
2DLD Change Limit1127162035.15621861.1
3Display Results2032030.0603383.3
 (SQL Overall)1786912035.60931857.9
 
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.