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

116 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
biotrons103724(None) 
biotron937291biotron_
bicrons113410472bi_crons
biotins93114452biot_ins
bistros92810982bistro_s
borons85520542b_o_rons
cistrons102710642cistrons
citrons92913222ci_trons
diatrons939622diatrons
introns73515022_introns
pliotrons1144712pliotrons
ailerons849853ailerons
amotions1069843amotions
barons85025383b__arons
bastions10411693bastions
batons85519423b_at_ons
baudrons1135763baudrons
benthons1337973benthons
bestrows1337043bestrows
betatrons1145083betatrons
betons84919553b_et_ons
bevatrons1443713bevatrons
biathlons14103333biathlons
bicorns11338763bicor_ns
bicron103710773bi_cron_
bigaroons1243943bigaroons
bighorns1445253bighorns
bigotries1286443bigotries
billions102211793billions
billons93013363bi_llons
biltong1034683bilt_ong
biltongs1133813bilt_ongs
binturong12112073binturong
binturongs1391253binturongs
biogens1038963bio_gens
biostrome1344613biostrome
biostromes1444043biostromes
biotas84313923biot__as
biotechs15123853biotechs
bioterrors1252693bioterrors
biotics113812173biot_ics
biotin83215833biot_in_
biotites10310093biotites
biotope1146623biot_ope
biotopes1246963biotopes
biotoxins1844183biotoxins
biotypes1544683biotypes
biparous1246923biparous
biros75325133bi__ro_s
bisons83914373bi__sons
bistorts10118813bistorts
bistres94017213bistr_es
bistro8339943bistro__
bistroic1246383bistroic
bitterns10428953bitterns
blousons1054403blousons
bolsons969483b_olsons
bonbons1139333b_onbons
boons75031913b_o__ons
boron76727143b_o_ron_
borrows12349263b_orrows
bosons85016653b_o_sons
bostons9312903b_ostons
bottoms1136993b_ottoms
bourbons1245343b_ourbons
bourdons1136433b_ourdons
bourns84114063b_our_ns
boutons9310783b_outons
burtons9310853burt_ons
buttons9310333b_uttons
cistron9299883cistron_
citrins92614363ci_trins
citron83112983ci_tron_
citrous93112993ci_trous
coitions10312853coitions
cottons9312193_cottons
crotons93714373crot_ons
cryotrons1444753cryotrons
diatron839283diatron_
dictions111812673dictions
diurons838823di_urons
emotions10610283emotions
fictions132410743fictions
girons75014373gi__rons
goitrous945763goitrous
hotrods1148283_hotrods
intron64215023_intron_
intros64215773_intro_s
irons55324133_i__rons
kenotrons1344523kenotrons
kilotons1286313kilot_ons
linurons846333linurons
lotions74614763_lotions
matrons93517633_matrons
mesotrons1145513mesotrons
microns113814783mi_crons
midirons1145883midirons
mikrons13428413mi_krons
morons84919543_mo_rons
motions94215003_motions
natrons73215663_natrons
neutrons838293neutrons
nitons64614903ni_t_ons
nitros64214123ni_tro_s
nitrous73512483ni_trous
notions74014483_notions
patrons93818103_patrons
photons123814433phot_ons
pistons93016373pist_ons
pitons85319043pi_t_ons
pliotron1044563pliotron_
potions93417423_potions
protons93118003prot_ons
riotous739873riot_ous
thorons104511913tho_rons
waitrons1136643waitrons

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621167.42019698.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.88922650.7
 
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.