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

144 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
biocide123732(None) 
biocides1336931biocides
biocidal1344942biocidal
biotite9311032biotite
bolide9515562b_olide
boride9415902b_oride
brocade1238532brocade
bromide12269582bromide
dioxide1656302dioxide
ecocide1246732ecocide
iodide84812932_iodide
bedside1156843bedside
beside95114613b_eside
betide95115973b_etide
biblike1536893biblike
bice86235563bi_c__e
bicorne11297553bicorne
bide76041483b___ide
bifid11910703bi_fid_
biggie103810933biggi_e
bigtime1235753bigtime
bikie113915883bi_ki_e
billie85019173billi_e
binocle1136493binoc_le
bioactive1644133bioactive
biochip1645323biochip
biochips1744843biochips
biocycle1743143biocycle
biofilm1444333biofilm
biome94916993bio__me
bionic103614573bioni_c
bionics114310873bionics
biopic123710673biopi_c
biopics13318543biopics
biopsied1344593biopsied
bioscope1446483bioscope
biotic103816603bioti_c
biotics113812173biotics
biotin83215823bioti_n
biotins93114453biotins
biotites10310083biotites
biotope1146623biotope
biotype1444423biotype
birched15349913birched
birdie94013783birdi_e
birdied11329433birdied
birkie124110133birki_e
bitched153212923bitched
blockade1744033blockade
blocked16449983blocked
blonde94813293blo_nde
blooie83913193blooi_e
bocce114313113b_oc_ce
boccie123311453b_occie
boche124216953b_oc_he
bode75838753b_o__de
bodice11711423b_odice
bodied103814583b_odied
bogie89524103b_ogi_e
boite74426323b_o_ite
bolides10515073b_olides
boobie104015293boobi_e
boogie93515993boogi_e
boogied11379283boogied
bookie123516003booki_e
bootie85421153booti_e
borides10515153b_orides
bovid111011623b_ovid_
bovids1287973b_ovids
bovine11712433b_ovine
bride86425533b__ride
brioche14275923brioc_he
brocaded1436353brocaded
brocades1358713brocades
broche133612103broc_he
broider103912973bro_ider
bromid112612893bromid_
bromides13219363bromides
bromids12278603bromids
bromine112915243bromine
bromize20238823bromize
brucine1138273brucine
coincide1346493coincide
crocine11314153crocine
decide104116873_decide
deicide1149403deicide
diacid10310633diacid_
diacids1137863diacids
diamide1138473diamide
diocese1036853diocese
diode74716113dio__de
diopside1245643diopside
diorite8314913diorite
dioxid1568393dioxid_
dioxides1756203dioxides
dioxids1655683dioxids
divide113410893di_vide
docile94213123_docile
ecocides1346583ecocides
epoxide1745343epoxide
excide1638423_excide
filicide1446363filicide
genocide1245693genocide
hircine1239143hircine
imide85716893_i_mide
incise83515333_incise
incite83618733_incite
inside7613453_inside
iodid74315533_iodid_
iodides93811613_iodides
iodids83711153_iodids
iodine74618653_iodine
iodise74214943_iodise
iodize164112593_iodize
iolite63221983_iolite
ionise63516943_ionise
ionize154613873_ionize
lionise7310373lionise
lionize1668823lionize
lipide93511063li_pide
miocene1147923miocene
miscite11314383miscite
miscode12310413miscode
miticide1347863miticide
nicoise937923nicoise
niobite937953niobite
nitride82811243nitride
oroide7311703oro_ide
ovicide1346433ovicide
oxide131210953__oxide
ozonide1754963ozonide
phocine1438833phocine
piscine11610973piscine
provide1339853provide
psocid1137253psocid_
psocids1234863psocids
riptide1036883riptide
silicide1147833silicide
suicide1038893suicide
trioxide1644793trioxide
viricide1446423viricide
virucide1443593virucide
viscid1237473viscid_
zincite1837233zincite

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.1561145455.1
2DLD Change Limit1340271447.51317839.3
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.71523161.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.