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

112 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
fibroid133724(None) 
fibroids1445841fibroids
fibroin1246471fibroin
ambroid1238882ambroid
fibril1137162fibr_il
fibrin1138532fibr_in
fibrinoid1553292fibrinoid
fibroins1346212fibroins
fibroma1444122fibroma
fibrosis1345452fibrosis
fibrotic1545722fibrotic
fibrous1237592fibrous
labroid1038822labroid
vibrioid1444402vibrioid
viroid10411522vi_roid
zebroid1936462zebroid
abroad9310943_abroad
acaroid103512313acaroid
amberoid1346433amberoid
ambroids1346503ambroids
android9311513android
aneroid8314003aneroid
aroid65428343__aroid
braid85822263__braid
broad84817693__broad
broil74918223__broil
bromid112612893__bromid
brood84620243__brood
ceboid11310653ceb_oid
choroid13311803choroid
ciboria1147043ciboria
cirsoid1038123cirsoid
cissoid1037343cissoid
cuboid1139503cub_oid
dibromide1543553dibromide
diploid11310293diploid
discoid11311243discoid
droid74218543__droid
embroil1146613embroil
embryoid1644403embryoid
emeroid101511183emeroid
fabric1337833fabr_ic
factoid1338693factoid
fervid1337513f_ervid
fibbed144011553fib_bed
fibered1337643fibered
fibre104812843fibr__e
fibres114312123fibr_es
fibrils1236843fibrils
fibrinoids1652443fibrinoids
fibrins1238633fibrins
fibromas1544403fibromas
fibroses1345973fibroses
filariid1244033filariid
fimbria1444453fimbr_ia
fiord94313343fi__ord
fired94829743fi_r_ed
firkin1337823fi_rkin
firmed125411883fi_rmed
florid10311453flor_id
fluorid1136783fluorid
forbid123312433f_orbid
fordid113512053f_ordid
frond95316343f__rond
fucoid1237893f_ucoid
fungoid1245253fungoid
gabbroid1452763gabbroid
gobioid1146023gobioid
histoid1139823histoid
hybrid15237813hybr_id
hydroid1539713hydroid
inroad737933_inroad
irid55927173_i_r_id
labroids1155843labroids
lianoid837533lianoid
libri74610113libr_i_
ligroin848043ligroin
lipoid9411043li_poid
lithoid1148773lithoid
negroid9108893negroid
neuroid81110303neuroid
nimrod934873nimro_d
nitrid72812233nitr_id
ochroid1357903ochroid
oidioid946053oidioid
pibroch1643803pibroch
sciuroid1144403sciuroid
sialoid8310963sialoid
sigmoid1146113sigmoid
siluroid945053siluroid
simioid1047993simioid
sistroid947263sistroid
sparoid102311543sparoid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314863steroid
tabloid1048263tabloid
theroid11313403theroid
thyroid1438253thyroid
toroid7416013_toroid
tuberoid1146013tuberoid
unbraid1037183unbraid
upbraid1244973upbraid
vibrio1136223vibr_io
vibrion1245253vibrion
vibrios1235803vibrios
vibronic1545133vibronic
virid94116043vi_r_id
viroids1137923vi_roids
viscoid1337023viscoid
xiphoid2045923xiphoid
zincoid1946663zincoid

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.423422437.4
2DLD Change Limit1340271127.06318975.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.53223724.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.