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

160 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
fibrous123759(None) 
cirrous93111062cirrous
citrous93112992citrous
cribrous1246012cribrous
ferrous1049802ferrous
fibres114312122fibr_es
fibrils1236842fibrils
fibrinous1443842fibrinous
fibrins1238632fibrins
fibroid1337242fibroid
fibroids1445842fibroids
fibroin1246472fibroin
fibroins1346212fibroins
fibroma1444122fibroma
fibromas1544402fibromas
fibroses1345972fibroses
fibrosis1345452fibrosis
fibrously1744952fibrously
gibbous1265332gibbous
nitrous73512482nitrous
acerous9513333acerous
airbus848343ai_rbus
amorous9311133amorous
anurous7311553anurous
arborous1047723arborous
aurous64119263_aurous
bibulous1244633bibulous
bicrons113410473bicrons
bijous1548043bi_jous
bilious9310933bilious
biparous1246923biparous
biros75325133bi_ro_s
broos75126413__broos
bros65635663__bro_s
brows105425983__brows
cerous85821203_cerous
cibols1039523cib_ols
circus104310593ci_rcus
cirrus8349173ci_rrus
citreous1056853citreous
citrons92913223citrons
citrus83610923citr_us
cumbrous1446173cumbrous
cuprous1149743cuprous
dimerous1139323dimerous
diurons838823diurons
dobros93910233dobro_s
dubious1036893dubious
estrous7712533estrous
fabrics1436093fabrics
fabulous1344853fabulous
famous11412393f_amous
faros85532023f_aro_s
farrows13259783farrows
fatuous1037783fatuous
ferreous1146043ferreous
feverous1446513feverous
fiars86720833fiar__s
fibbers144510603fibbers
fibers114717523fib_ers
fibre104812843fibr__e
fibril1137163fibr_il
fibrin1138533fibr_in
fibrotic1545723fibrotic
fibs96329503fib___s
fibulas12228563fibulas
fichus14388113fi_chus
ficoes114613463fi_coes
ficus105015493fi__cus
fidos95819053fi_do_s
fillos94415083fillo_s
filos86125383fi_lo_s
finos86226953fi_no_s
fiords10498623fior_ds
firers94922683fi_rers
fires85740753fi_r_es
firms105217423fi_r_ms
firns86018543fi_r_ns
firs76637713fi_r__s
firsts95110923fi_rsts
firths125113503fi_rths
folious103710733folious
frabjous2042633frabjous
froes86126693f__roes
frogs96220773f__rogs
frons86124043f__rons
frows116623103f__rows
fucous11399863f_ucous
fulvous1334543fulvous
fungous11367433fungous
furious103110633furious
furors9310953f_urors
furrows13327793furrows
fuscous1256673fuscous
gibbons1234983gibbons
gibsons1045043gibsons
girons75014373gi_rons
giros65722653gi_ro_s
glabrous1145533glabrous
goitrous945763goitrous
hideous1168433hideous
hydrous14197883hydrous
iodous7311503_iodous
irons55324133_i_rons
leprous938843leprous
libelous1047193libelous
libras83711703libr_as
miaous8511693mi_aous
microbus1456033microbus
microns113814783microns
micros104115363micro_s
mikrons13428413mikrons
mirrors938623mirrors
nimious937663nimious
nimrods1044283nimrods
niobous936333niobous
nitros64214123nitro_s
niveous1037193niveous
ochrous1237943ochrous
odorous837663odorous
onerous7312973onerous
parous84024163_parous
petrous92714423petrous
pibroch1643803pibroch
pibrochs1743213pibrochs
piceous11310693piceous
pileous9510523pileous
pilous84717753pi_lous
pious74621273pi__ous
pistous92714383pistous
piteous9310683piteous
porous84419483_porous
ribbons1136253ribbons
rigorous947373rigorous
rimous8311913ri_mous
riotous739863riotous
rubious938283rubious
scabrous1245993scabrous
serous65023563_serous
simious939803simious
sinuous739063sinuous
sombrous1246613sombrous
suberous10311793suberous
timeous938403timeous
timorous1047433timorous
tiros54524893ti_ro_s
torous64319033_torous
tuberous1047493tuberous
vibrions1345093vibrions
vibrios1235803vibrios
vicious1239493vicious
vigorous1245763vigorous
villous102810023villous
vinous93914173vi_nous
viperous1347613viperous
virtus94310143vi_rtus
virus85316843vi_r_us
viscous1238833viscous
vitreous1145843vitreous
zincous1837053zincous

Search took 9 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.470380193.6
2DLD Change Limit1340271607.75017293.8
3Display Results1601600.0632539.7
 (SQL Overall)1786911608.28321573.2
 
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.