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

297 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
bicrons11341047(None) 
bicorns11338751bicorns
bicron103710771bicron_
microns113814781microns
bacons104917582bac_ons
barons85025382b_arons
beckons15279142beckons
bicorn103610102bicorn_
bicorne11297552bicorne
bicornes12307252bicornes
billons93013352billons
biotrons1037232biotrons
biros75325132bi_ro_s
bisons83914372bi_sons
borons85520542b_orons
citrons92913222citrons
dacrons103211032dacrons
diurons838822diurons
girons75014372gi_rons
icons76516492_ic_ons
irons55324132_i_rons
macrons113514892macrons
micron103714282micron_
micros104115362micro_s
mikrons13428412mikrons
omicrons1275192omicrons
zircons1854962zircons
acorns85013013_acorns
across8312643_across
ailerons849833ailerons
airns55521033ai_r_ns
aprons8316993_aprons
archons12311583archons
baboons113211073baboons
bacon95620593bac_on_
bairns86710873bair_ns
ballons93916953ballons
barns76335143b_ar_ns
baron78131243b_aron_
barong96015823b_arong
barongs105310833b_arongs
barony115915303b_arony
barrens94414323barrens
barrows123411683barrows
baryons121010473baryons
basions94213953basions
batons85519423b_atons
baudrons1135763baudrons
beacons11410733beacons
beckon14309383beckon_
beclogs1237073beclogs
beclowns1544683beclowns
becrowd1555173becrowd
becrowds1683773becrowds
begroans1145503begroans
belons84119413b_elons
betons84919553b_etons
bicarbs1336013bicarbs
biceps12447713bic_eps
bices95029963bic__es
bichrome1745653bichrome
bickers154316553bickers
bicolors1256163bicolors
biers76225223bier__s
biffins15358533biffins
bigaroons1243943bigaroons
biggins113410693biggins
bighorns1445243bighorns
bigos85020013bi_go_s
bigots95015133bi_gots
bijous1548043bi_jous
bilboas11438723bilboas
bilboes114410233bilboes
bilbos105011193bilbo_s
bilious9310933bilious
billions102211783billions
billon83713823billon_
billows123611283billows
biltong1034683biltong
biltongs1133813biltongs
bimboes13498733bimboes
bimbos124610523bimbo_s
bingoes104013983bingoes
bingos95514793bingo_s
binocs1039923bi_nocs
bins66548253bi___ns
biogens1038963biogens
biogs85016113bi__ogs
biont7727163bi__ont
bionts8612393bi__onts
bios66335323bi__o_s
biotins93114453biotins
biotron937293biotron_
biparous1246923biparous
bipods11408593bi_pods
birches143412323birches
birds85421333bi_r_ds
birks114920303bi_r_ks
birles84920643bi_rles
birls74023163bi_r_ls
biro66131213bi_ro__
birring103713063birring
birrs74917103bi_r_rs
birses84717733bi_rses
births115713603bi_rths
bishops1437033bishops
bison75716983bi_son_
bistros92810983bistro_s
bizone1738603bi_zone
bizones1837823bi_zones
blazons1836163blazons
bolsons969483bolsons
bonbons1139333bonbons
boons75031913b__oons
boron76727143b_oron_
borrows12349253borrows
bosons85016653b_osons
bostons9312893bostons
bourbons1245343bourbons
bourdons1136423bourdons
bourns84114063bour_ns
boutons9310783boutons
brans75437433b__rans
brens75823363b__rens
bridoons1145423bridoons
brins75533973b__rins
bronc91714343b__ronc
broncs101611153b__roncs
broos75126413b__roos
bros65635663b__ro_s
browns116415633b__rowns
brows105425983b__rows
buckoes153810393buckoes
buckos143710893bucko_s
bunions92210473bunions
burans85019303b_urans
burins84221893b_urins
burns74926773b_ur_ns
burros85114993burro_s
burrows12399093burrows
burtons9310853burtons
buttons9310333buttons
cicerone1247523cicerone
cicerones1347073cicerones
ciceroni1244853ciceroni
ciceros1158573cicero_s
cions75222853__cions
cirrous93111063cirrous
cistrons102710623cistrons
citrins92614363citrins
citron83112983citron_
citrous93112983citrous
clons75228133__clons
cocoons11310563cocoons
cons66057693__c_ons
coons76737283__coons
corns76034763__corns
crocs95722433__crocs
crone75231333__crone
crones84729243__crones
crony105918673__crony
croons85418423__croons
crops96125233__crops
cross75124503__cross
crowns115615113__crowns
crows105727313__crows
dacron94310693dacron_
decrowns14265063decrowns
diatrons939613diatrons
dickens144410133dickens
dicots94915793dic_ots
dictions111812673dictions
discrowns1544663discrowns
diuron738573diuron_
eikons1038503ei_kons
escrows1235803escrows
fibrins1238633fibrins
fibroins1346213fibroins
fibrous1237593fibrous
ficins113513983fic_ins
ficoes114613463fic_oes
fictions132410743fictions
firns86018543fi_r_ns
frons86124043__frons
garcons102411643garcons
garrons82713463garrons
gibbons1234973gibbons
gibsons1045043gibsons
gipons9389603gi_pons
girns64516803gi_r_ns
giron66118993gi_ron_
giros65722653gi_ro_s
gyrons105511223_gyrons
hadrons113314303hadrons
herons94820543_herons
ichors11310413_ichors
icon66922043_ic_on_
icones84616383_ic_ones
ikons96311013_i_kons
incross937663incross
inions64417003_inions
inruns6359513_inruns
introns73515023introns
ions46737853_i__ons
iron46728463_i_ron_
irone55126363_i_rone
irones64724013_i_rones
irony85015903_i_rony
kirns95315453ki_r_ns
ladrons83813193ladrons
lichens123510683lichens
lictors93212583lictors
ligroins946823ligroins
linurons846333linurons
lions55923213li__ons
macons104017243mac_ons
macron103615673macron_
macros104017013macro_s
marrons93216973marrons
matrons93517633matrons
micro94715993micro__
microbe1338663microbe
microbes1439403microbes
microbus1456033microbus
microhm1646123microhm
microhms1765603microhms
midirons1145883midirons
mignons1037863mignons
mikron12318503mikron_
minions93314623minions
mirins83918903mi_rins
mirrors938623mirrors
morons84919543_morons
mucrones1237603mucrones
natrons73215663natrons
neurons7410443neurons
nicols8810243nic_ols
nimrods1044283nimrods
ninons64913773ni_nons
nitons64614903ni_tons
nitros64214123nitro_s
nitrous73512483nitrous
omicron1165063omicron_
omikrons1462963omikrons
operons91411743operons
patrons93818103patrons
perrons93115483perrons
picaroons1344673picaroons
picaros11310893picaro_s
piceous11310693piceous
picots104616443pic_ots
pigeons1039183pigeons
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393pi__ons
pirns76020093pi_r_ns
pistons93016373pistons
pitons85319043pi_tons
racons84319343rac_ons
racoons93912433racoons
reckons13269653reckons
recons84922993rec_ons
recross989833recross
recrowns13246143recrowns
ribbons1136243ribbons
richens12349733richens
ricins83618703ric_ins
ricracs1136363ricracs
scions82612233_scions
scorns85713013_scorns
scrods94111603_scrods
sickens134411483sickens
sickos125112033sicko_s
simoons937933simoons
siphons1239343siphons
sirens65318153si_rens
thorons104511913thorons
tictocs1145903tictocs
tiglons837333tiglons
tigons74112253ti_gons
tiros54524893ti_ro_s
tricorns1036673tricorns
tycoons1235173tycoons
uncross938193uncross
uncrowns1344363uncrowns
unicorns1044763unicorns
vibrions1345093vibrions
viceroys1644103viceroys
vicious1239493vicious
victors123311173victors
virions1039873virions
visions10311023visions
waitrons1136633waitrons
wiccans1434603wiccans
wigeons1136983wigeons
zircon1754953zircon_

Search took 9 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.186960704.3
2DLD Change Limit1340272977.81317154.4
3Display Results2972970.1102700.0
 (SQL Overall)1786912978.10922036.1
 
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.