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

102 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
bicornes1230725(None) 
bicorne11297551bicorne_
bicorns11338761bicorn_s
bicorn103610102bicorn__
bicrons113410472bicron_s
bizones1837822bizo_nes
cicorees1246412cicorees
icones84616382_ico_nes
tricornes1146232tricornes
acorned10238273_acorned
acorns85013013_acorn_s
albicores1343513albicor_es
ancones93116343anco_nes
bacons104917583baco_n_s
baronnes1038553baronnes
becomes132911963beco_mes
becurses1236723becurses
bicarbs1336013bicar_bs
bicepses1443873bicepses
bices95029963bic___es
bicolors1256163bicolors
biconvex2241863biconvex
bicron103710773bicron__
bicycles1743883bicycles
biforked1842873biforked
biformed1643693biformed
bighorns1445253bighorn_s
bigoses1039073bigo_ses
bigotries1286443bigotries
bimorphs1743473bimorphs
binaries10314183binaries
bines76946793bi___nes
binocles1236413binocles
biocides1336933biocides
biogens1038963bi_ogens
biomes103815253bi_o_mes
bionts8612393bi_o_nts
biplanes1238573biplanes
birles84920643bi__rles
birses84717733bi__rses
bisons83914373biso_n_s
bistres94017213bistr_es
bizarres1953793bizarres
bizone1738603bizo_ne_
bones76446533b__o_nes
bonnes85621453b__onnes
boranes93720403b__oranes
bores76448253b__or_es
borne77926793b__orne_
bournes93615023b_ournes
bricoles122610303brico_les
bygones1335913bygo_nes
chicories1688763chicories
cicerones1347073cicerones
cicoree1149843cicor_ee
cones76457423__co_nes
cores76361853__cor_es
cornea84018923__cornea
corneas94717003__corneas
corned95224523__corned
cornel84020053__cornel
cornels94716663__cornels
corner84625623__corner
corners94723313__corners
cornet84436733__cornet
cornets94820573__cornets
corns76034763__corn_s
cornus84816563__cornus
corses84433463__corses
corves115122523__corves
crones84729243__crones
divorces1445673divorces
eikones1137853eiko_nes
encores9315213encor_es
ficoes114613463fico__es
hickories1845313hickories
icons76516493_ico_n_s
irones64724013_iro_nes
ivories10310713_ivories
licorices1346353licorices
liernes739623li_ernes
lucarnes1045093lucarnes
lucernes1046363lucernes
microbes1439403microbes
microns113814783micron_s
mucrones1237603mucrones
nicotines1148353nicotines
picolines1339623picolines
picotees1247113picotees
pinones94717073pino_nes
scones84521303_sco_nes
scores84725923_scor_es
scorned10229953_scorned
scorner9259763_scorner
scorners10228493_scorners
scorns85713023_scorn_s
tricorne1045963tricorne_
tricorns1036683tricorn_s
unicorns1044773unicorn_s
vicomtes1545593vicomtes
victories1448913victories
wicopies1545983wicopies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621027.61019206.6
3Display Results1021020.0303400.0
 (SQL Overall)1786911028.06322161.9
 
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.