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

105 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
bicorne1129755(None) 
bicorn103610101bicorn_
bicornes12307251bicornes
bicorns11338761bicorns
bicron103710772bicron_
bicrons113410472bicrons
bizone1738602bizo_ne
borne77926792b__orne
cicoree1149842cicoree
tricorne1045962tricorne
acorn75616623_acorn_
acorned10238283_acorned
acorns85013013_acorns
airborne1044513airborne
albicore1243713albicor_e
ancone83916953anco_ne
bacon95620593baco_n_
bacons104917583baco_ns
baronne938273baronne
become123312593beco_me
becurse1136183becurse
before11410153befor_e
begone9512133bego_ne
bicarb1238543bicar_b
bicarbs1336013bicarbs
bice86235563bic___e
bichrome1745653bichrome
bicolor1145613bicolor
biconvex2241863biconvex
bicycle1643993bicycle
biforate1346903biforate
biforked1842873biforked
biform1368123bifor_m
biformed1643693biformed
bighorn1346063bighorn_
bighorns1445253bighorns
bimorph1643623bimorph
bine66650863bi___ne
binocle1136493binocle
biocide1237323biocide
biogen9310253bi_ogen
biome94916993bi_o_me
biont7727163bi_o_nt
biplane1139033biplane
birle75023633bi__rle
birse74517403bi__rse
bison75716983biso_n_
bisons83914373biso_ns
bistre83815023bistr_e
bizarre1844103bizarre
bizones1837823bizo_nes
bone65949323b__o_ne
bonne75124713b__onne
borane84620213b__orane
bore66051333b__or_e
born67338413b__orn_
bourne83714093b_ourne
bricole112810493brico_le
bygone1256173bygo_ne
cicerone1247523cicerone
cicorees1246413cicorees
cone67256963__co_ne
core67263113__cor_e
corn69945813__corn_
cornea84018933__cornea
corned95224523__corned
cornel84020053__cornel
corner84625623__corner
cornet84436733__cornet
corns76034763__corns
cornu75921323__cornu
corny106023273__corny
corse75036183__corse
crone75231333__crone
divorce1344813divorce
encore8314773encor_e
icon66922043_ico_n_
icones84616383_ico_nes
icons76516493_ico_ns
irone55126363_iro_ne
licorice1246143licorice
lierne638023li_erne
lucarne944263lucarne
lucerne945753lucerne
microbe1338663microbe
micron103714283micron_
microns113814783microns
miocene1147923miocene
nicoise937933nicoise
nicotine1058473nicotine
picoline12310853picoline
picotee11311473picotee
scone74621833_sco_ne
score75526743_scor_e
scorn75817453_scorn_
scorned10229953_scorned
scorner9259763_scorner
scorns85713023_scorns
tricorn937963tricorn_
tricornes1146233tricornes
tricorns1036683tricorns
unicorn946513unicorn_
unicorns1044773unicorns
upborne11255133upborne
vicomte1445723vicomte

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271055.97022450.1
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.42327820.5
 
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.