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

119 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
biotron93729(None) 
biotrons1037241biotrons
bicron103710772bi_cron
biotin83215832biot_in
bistro8339942bistro_
bistros92810982bistros
boron76727142b_o_ron
cistron9299882cistron
citron83112982ci_tron
diatron839282diatron
intron64215022_intron
pliotron1044562pliotron
aileron739833aileron
amotion9710473amotion
baron78131243b__aron
bastion9312473bastion
baton75822423b_at_on
benthon1237693benthon
bestrow1237253bestrow
bestrown1345203bestrown
betatron1045233betatron
beton76022063b_et_on
bevatron1343883bevatron
biathlon13153013biathlon
bicorn103610103bicor_n
bicrons113410473bi_crons
bigaroon1144593bigaroon
bighorn1346063bighorn
bigotry1344523bigotr_y
billion92212173billion
billon83713833bi_llon
biltong1034683bilt_ong
binturong12112073binturong
biogen9310253bio_gen
biostrome1344613biostrome
biota74516823biot__a
biotas84313923biot_as
biotech14104493biotech
bioterror1152243bioterror
biotic103816613biot_ic
biotics113812173biotics
biotins93114453biotins
biotite9311033biotite
biotope1146623biotope
biotoxin1744273biotoxin
biotype1444423biotype
biro66131223bi__ro_
biros75325133bi__ros
bison75716983bi__son
bistort91216523bistort
bistre83815023bistr_e
bistred103311853bistred
bistres94017213bistres
bistroic1246383bistroic
bitten84715123bi_tten
bittern94810683bittern
blotto8198443blotto_
blouson974893blouson
bolson8410683b_olson
bonbon10310073b_onbon
boon67142173b_o__on
born67338413b_o_r_n
borons85520543b_o_rons
borrow114310733b_orrow
boson76019733b_o_son
boston8513043b_oston
bottom1048723b_ottom
bourbon1135813b_ourbon
bourdon1036423b_ourdon
bourn75518483b_our_n
bouton8311533b_outon
burton8311273burt_on
button8310273b_utton
cistrons102710643cistrons
citrin82615413ci_trin
citrons92913223ci_trons
coition9314313coition
cotton8312993_cotton
croton84415453crot_on
cryotron1344373cryotron
diatrons939623diatrons
diction102313053diction
dipteron1145593dipteron
diuron738573di_uron
elytron1045463elytron
emotion9711303emotion
fiction122010733fiction
giron66118993gi__ron
hotrod1048803_hotrod
intro54915853_intro_
introns73515023_introns
intros64215773_intros
iron46728463_i__ron
kenotron1244463kenotron
kiloton1196313kilot_on
linuron746513linuron
lotion65716523_lotion
matron83918313_matron
mesotron1045383mesotron
micron103714283mi_cron
midiron1046003midiron
mikron12318503mi_kron
moron76925423_mo_ron
motion85217553_motion
natron64116023_natron
neutron737763neutron
niton55418283ni_t_on
nitro54914353ni_tro_
nitros64214123ni_tros
notion64516583_notion
patron84018043_patron
photon1111514833phot_on
piston83515923pist_on
piton76121583pi_t_on
pliotrons1144713pliotrons
potion84519573_potion
proton84318893prot_on
thoron94713903tho_ron
waitron1036333waitron

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.470380193.6
2DLD Change Limit1340271196.70319995.1
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.