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

302 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
bicron10371077(None) 
bicorn103610101bicorn
bicrons113410471bicrons
micron103714281micron
bacon95620592bac_on
baron78131242b_aron
beckon14309382beckon
bicorne11297552bicorne
bicorns11338762bicorns
billon83713832billon
biotron937292biotron
biro66131222bi_ro_
biros75325132bi_ros
bison75716982bi_son
boron76727142b_oron
citron83112982citron
dacron94310692dacron
diuron738572diuron
giron66118992gi_ron
icon66922042_ic_on
iron46728462_i_ron
macron103615672macron
micro94715992micro_
microns113814782microns
micros104115362micros
mikron12318502mikron
omicron1165062omicron
zircon1754952zircon
acorn75616623_acorn
aileron739833aileron
airn46433843ai_r_n
ancon75718233anc_on
apron7318833_apron
archon11311753archon
baboon103613913baboon
bacons104917583bac_ons
bairn77515533bair_n
ballon84117493ballon
barn66444643b_ar_n
barong96015823b_arong
barons85025383b_arons
barony115915303b_arony
barren85317623barren
barrow114512773barrow
baryon111211613baryon
basion84315853basion
baton75822423b_aton
beacon10511373beacon
beckons15279143beckons
beclog1136863beclog
beclown1435423beclown
becrowd1555183becrowd
begroan1036103begroan
belon73924113b_elon
beton76022063b_eton
bicarb1238543bicarb
bicarbs1336013bicarbs
bice86235573bic__e
bicep115413543bic_ep
biceps12447713biceps
bices95029963bic_es
bichrome1745653bichrome
bicker144819173bicker
bicolor1145613bicolor
bicornes12307253bicornes
bidden104010793bidden
bier65531843bier__
biers76225223bier_s
biffin14369103biffin
biform1368133biform
bigaroon1144593bigaroon
biggin103710603biggin
bighorn1346063bighorn
bigos85020013bi_gos
bigot84828323bi_got
bijou1458793bi_jou
bilbo95513613bilbo_
bilboa10367843bilboa
bilbos105011203bilbos
billion92212173billion
billons93013363billons
billow114111223billow
biltong1034683biltong
bimbo114811873bimbo_
bimbos124610523bimbos
bin56658653bi___n
bingo86020093bingo_
bingos95514793bingos
bio57846093bi__o_
biog76122333bi__og
biogen9310253biogen
biont7727163bi__ont
bios66335333bi__os
biotin83215833biotin
biotrons1037243biotrons
bipod104410823bi_pod
birch124914023bi_rch
birchen14347883birchen
bird76128333bi_r_d
birds85421343bi_rds
birk106326873bi_r_k
birks114920303bi_rks
birl65830483bi_r_l
birle75023633bi_rle
birls74023163bi_rls
birr66022373bi_r_r
birred94713203birred
birring103713063birring
birrs74917103bi_rrs
birse74517403bi_rse
birth105619873bi_rth
bishop1336943bishop
bisons83914373bi_sons
bistro8339943bistro_
bistros92810983bistros
bitchen14349733bitchen
bitten84715123bitten
bizone1738603bi_zone
blazon1736763blazon
bolson8410683bolson
bonbon10310073bonbon
boon67142173b__oon
born67338413b_or_n
borons85520543b_orons
borrow114310733borrow
boson76019733b_oson
boston8513043boston
bourbon1135813bourbon
bourdon1036423bourdon
bourn75518483bour_n
bouton8311533bouton
bran65740383b__ran
bren65629563b__ren
bridoon1046203bridoon
brin67038193b__rin
bro56236603b__ro_
bronc91714343b__ronc
broo65129823b__roo
bros65635663b__ros
brow97228443b__row
brown105619533b__rown
bucko134614023bucko_
buckos143710893buckos
bunion83111313bunion
buran75225303b_uran
burin75626063b_urin
burn65636433b_ur_n
burro75018493burro_
burros85114993burros
burrow114610813burrow
burton8311273burton
button8310273button
chon96627793__chon
cicero1048503cicero_
cicerone1247523cicerone
ciceroni1244853ciceroni
ciceros1158593ciceros
cion613330923__cion
cistron9299883cistron
citrin82615413citrin
citrons92913223citrons
clon66232483__clon
cocoon10312263cocoon
con510268023__c_on
coon67248943__coon
corn69945813__corn
croc85723733__croc
crone75231333__crone
crony105918673__crony
croon75522783__croon
crop87628633__crop
crow96428133__crow
crown105620083__crown
dacrons103211033dacrons
decrown13206053decrown
diatron839283diatron
dicot85429093dic_ot
diction102313053diction
discrown1445283discrown
diurons838823diurons
eikon939463ei_kon
escrow1135913escrow
fibrin1138533fibrin
fibroin1246473fibroin
ficin103516723fic_in
fico95824603fic_o_
fiction122010733fiction
firn76927513fi_r_n
garcon92912483garcon
garron73113493garron
gibbon1135323gibbon
gibson935123gibson
gipon84212413gi_pon
girn56026873gi_r_n
giro55828643gi_ro_
girons75014373gi_rons
giros65722653gi_ros
gyron95314623_gyron
hadron102913753hadron
heron85025503_heron
ichor1039483_ichor
icons76516493_ic_ons
ikon85814963_i_kon
inion54620183_inion
inro45920793_inro_
inrun52911373_inrun
intron64215023intron
ion36051033_i__on
irone55126363_i_rone
irons55324133_i_rons
irony85015903_i_rony
kirn87123453ki_r_n
ladron73413323ladron
lichen114012743lichen
lictor83610863lictor
ligroin848043ligroin
linuron746513linuron
lion46334453li__on
lirot5430033li_rot
macon94519953mac_on
macro94718173macro_
macrons113514893macrons
macros104017013macros
marron83717543marron
matron83918313matron
micra96214973micr_a
microbe1338663microbe
microhm1646123microhm
midiron1046003midiron
mignon937953mignon
mikrons13428413mikrons
minion83416243minion
mirin75023153mi_rin
mirror848003mirror
moron76925423_moron
mucro94513723mucro_
natron64116023natron
neuron6310373neuron
nicol71113293nic_ol
nimrod934873nimrod
ninon55517383ni_non
niton55418283ni_ton
nitro54914353nitro_
nitros64214123nitros
omicrons1275193omicrons
omikron1353173omikron
operon8811773operon
patron84018043patron
perron83216623perron
picaro10311323picaro_
picaroon1245653picaroon
picaros11310893picaros
picot95031013pic_ot
picric12309923picric
pigeon949413pigeon
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235303pi__on
pirn67128383pi_r_n
pirog83913673pi_rog
piston83515923piston
piton76121583pi_ton
racon75422143rac_on
racoon83814473racoon
reckon123010543reckon
recon75624243rec_on
recrown12257573recrown
ribbon1036533ribbon
richen113812513richen
ricin74620213ric_in
ricrac1037013ricrac
scion72214993_scion
scorn75817453_scorn
scrod85115073_scrod
siccan1037593siccan
sicken124615253sicken
sicko115315393sicko_
sickos125112033sickos
simoon858063simoon
siphon1138463siphon
siren54525823si_ren
submicron1552433submicron
thoron94713903thoron
tictoc1036003tictoc
tiglon737923tiglon
tigon63914443ti_gon
tiro46832373ti_ro_
tiros54524893ti_ros
tricorn937963tricorn
tycoon1136023tycoon
uncrown1236323uncrown
unicorn946513unicorn
vibrion1245253vibrion
viceroy1544933viceroy
victor113210673victor
virion9310683virion
vision9311313vision
waitron1036333waitron
wiccan1335033wiccan
wigeon1037223wigeon
zircons1854963zircons

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127163025.14021929.2
3Display Results3023020.0933247.3
 (SQL Overall)1786913025.60931857.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.