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

286 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
bicorn10361010(None) 
bicorne11297551bicorne
bicorns11338761bicorns
bicron103710771bicron
acorn75616622_acorn
bacon95620592baco_n
bicarb1238542bicarb
bicornes12307252bicornes
bicrons113410472bicrons
biform1368122biform
bighorn1346062bighorn
bison75716982biso_n
born67338412b__orn
corn69945812__corn
icon66922042_ico_n
micron103714282micron
scorn75817452_scorn
tricorn937962tricorn
unicorn946512unicorn
accord1178843accord
acorns85013013_acorns
adorn64917093_adorn
airn46433833ai__rn
albicore1243713albicore
ancon75718233anco_n
attorn6310793attorn
baboon103613913baboon
bacons104917583bacons
bailor83412603bailor_
bailors93212413bailors
bairn77515533b_airn
barn66444643b__arn
baron78131243baro_n
baton75822423bato_n
beacon10511373beaco_n
beckon14309383beckon
beclown1435423beclown
become123312593become
before11410153before
belon73924113belo_n
bemoan10310253bemoan
bethorn1238643bethorn
beton76022063beto_n
bevor101510813bevor_
bevors111610343bevors
beworm1339993beworm
bibcock1943533bibcock
bicarbs1336013bicarbs
bice86235563bic__e
bicep115413543bic_ep
biceps12447713biceps
bices95029963bic_es
bicker144819173bicker
bickers154316553bickers
bicolor1145613bicolor
bicolors1256163bicolors
bidden104010793bidden
bider85728373bider_
biders94822803biders
bier65531833bi_er_
biers76225223bi_ers
biffin14369103biffin
bifold1237223bifold
biggin103710603biggin
bighorns1445253bighorns
bigos85020013bigo_s
bigot84828323bigo_t
bigotry1344523bigotry
bigots95015133bigots
bijou1458793bijo_u
bijous1548043bijous
bijoux2253453bijoux
biker116022563biker_
bikers124517553bikers
billon83713833billon
bimorph1643623bimorph
bin56658643bi___n
binary11312223binary
biner75930693biner_
biners85023633biners
binocs1039923binocs
bio57846083bi_o__
biog76122323bi_o_g
biogen9310253biogen
biogs85016113bi_ogs
biome94916993bi_ome
biont7727163bi_ont
bios66335323bi_o_s
biota74516823bi_ota
biotin83215833biotin
biotron937293biotron
bipod104410823bipo_d
bipods11408593bipods
birchen14347883birchen
bird76128323bi__rd
birk106326863bi__rk
birl65830473bi__rl
biro66131213bi__ro
biros75325133biro_s
birr66022363bi__rr
birrs74917103bi_rrs
bisons83914373bisons
bistort91216523bistort
bistre83815023bistre
bistro8339943bistro
bitchen14349733bitchen
biter75030033biter_
biters83925243biters
bitten84715123bitten
bittern94810683bittern
bizone1738603bizone
blown105716673b_lown
boon67142173b__oon
boor66130683b_oor_
boors74325013b_oors
bora66141633b__ora
bore66051333b__ore
bork106933823b__ork
borne77926793b__orne
boron76727143b__oron
bort65960963b__ort
boson76019733boso_n
bourn75518483b_ourn
bricole112810493bricole
bridoon1046203bridoon
brown105619533b_rown
buckra1436753buckra
burn65636433b__urn
byword1535053byword
bywork1834863bywork
carn66245433__carn
cavicorn1543833cavicorn
chicory1735993chicory
cicero1048503cicero
cicoree1149843cicoree
cion613330913ci_o_n
citron83112983citron
cocoon10312263cocoon
coin66645353__coin
con510268023__co_n
conn66229133__conn
coon67248943__coon
cor59960943__cor_
cord76740923__cord
core67263113__core
corf95941483__corf
cork106635693__cork
corm85735383__corm
corns76034763__corns
cornu75921323__cornu
corny106023273__corny
cors66656443__cors
cory96941513__cory
curn66731893__curn
dacron94310693dacron
decern91310953decern
decor84717573decor_
decors94017773decors
dehorn10439653dehorn
dicer85426423dicer_
dicers94720743dicers
dicot85429093dico_t
dicots94915793dicots
discern1038493discern
discord1139993discord
disown1036953disown
diuron738573diuron
eikon939463eiko_n
einkorn1144223einkorn
encore8314773encore
escort84616483escort
ficin103516723fic_in
fico95824593fico__
ficoes114613463ficoes
fiord94313343fi_ord
firn76927503fi__rn
gipon84212413gipo_n
girn56026863gi__rn
giron66118993giro_n
hickory1943903hickory
horn76735613__horn
ichor1039483_ichor_
ichors11310423_ichors
icons76516493_icons
ikon85814953_iko_n
inborn8319143inborn
inurn53712863_inurn
ion36051023_i_o_n
iron46728463_iro_n
ivory1137373_ivory
ixora1236913_ixora
kirn87123443ki__rn
lichen114012743lichen
lictor83610863lictor_
lictors93212603lictors
lion46334443li_o_n
lorn46435253__lorn
lucern846103lucern
macon94519953maco_n
macron103615673macron
micra96214973mic_ra
micro94715993mic_ro
microns113814783microns
micros104115363micros
mikron12318503mikron
milord999573milord
minor74920063minor_
minors85117103minors
miscoin11311433miscoin
morn66237563__morn
mucor94011943mucor_
mucors104410853mucors
nicer74618293nicer_
nicol71113293nico_l
nicols8810243nicols
nicotin948383nicotin
ninon55517383nino_n
niton55418283nito_n
omicron1165063omicron
picara10311903picara
picaro10311323picaro
picolin11310883picolin
picot95031013pico_t
picots104616443picots
pinon76024533pino_n
pion67235293pi_o_n
pirn67128373pi__rn
piton76121583pito_n
popcorn1344903popcorn
porn65636023__porn
racon75422143raco_n
racoon83814473racoon
reborn810016963reborn
recoin84320293recoin
recon75624243reco_n
record96117433record
recork126315493recork
retorn610923433retorn
reworn98122203reworn
ricer74726613ricer_
ricers84120993ricers
richen113812513richen
ricin74620213ric_in
rigor62714053rigor_
rigors72813713rigors
ripcord1264463ripcord
scion72214993scio_n
score75526743_score
scorns85713023_scorns
secern81010223secern
shorn85722183_shorn
siccan1037593siccan
sicken124615253sicken
simoon858063simoon
sorn46641063__sorn
suborn8310013suborn
sworn86115313_sworn
thorn85318703_thorn
tigon63914443tigo_n
tinhorn1046033tinhorn
torn46044253__torn
tricorne1045963tricorne
tricorns1036683tricorns
tycoon1136023tycoon
unborn83310813unborn
uncork1239043uncork
unicorns1044773unicorns
untorn63012343untorn
unworn93411333unworn
uptorn8268093uptorn
vicar10513863vicar_
vicars11712263vicars
victor113210673victor_
victors123311183victors
victory15326983victory
vigor92612423vigor_
vigors102911483vigors
visor82512833visor_
visors92912223visors
vizor173010093vizor_
vizors18328903vizors
wiccan1335033wiccan
wicopy1634033wicopy
wivern12409283wivern
worn75631753__worn
zircon1754953zirco_n

Search took 7 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.406440125.6
2DLD Change Limit1127162865.62620034.8
3Display Results2862860.0933075.3
 (SQL Overall)1786912866.12529174.0
 
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.