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

308 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
bornite931118(None) 
bornites10310971bornites
barite84224812bar_ite
boite74426322bo__ite
bonita8312942bo_nita
bonito8313432bo_nito
bonnie85314852bonni_e
boracite1249192boracite
borate85026152bor_ate
boride9415902bor_ide
borne77926792born__e
bornitic1246472bornitic
burkite1337002burkite
burnie83715412burni_e
byrnie11348572byrni_e
cordite10315252cordite
cornice11612932cornice
cornute939632cornute
ebonite9310292ebo_nite
hornito1047072hornito
kernite1159472kernite
norite63221132nor_ite
ornate6315132_ornate
aborning1188003aborning
abortive1346883abortive
aconite9315473aconite
alunite7311633alunite
arenite71017713arenite
barbate11314543barbate
barbie105018353barbi_e
barites94322333bar_ites
barmie103816393barmi_e
barnier93213673barnier
barning104320353barning
barnlike1437183barnlike
baryte115312883bar_yte
bauxite1635573bauxite
beanie83618593beani_e
berate84729023ber_ate
berime105317333ber_ime
berline93716853berline
bernicle1245443bernicle
binate8419773b_inate
binit76431583b_init_
binits85716673b_inits
biotite9311033biotite
birdie94013783birdi_e
birkie124110133birki_e
bite66546993b___ite
blite76225353b__lite
bobwhite1842423bobwhite
boccie123311443bocci_e
bodice11711423bo_dice
boehmite1583153boehmite
bogie89524103bo_gi_e
boites84322703bo__ites
bolete8519613bo_lete
bolide9515563bo_lide
bone65949323bo_n__e
bonfire1287063bonfire
boniato947283bo_niato
bonier84321993bo_nier
boning94223293bo_ning
bonitas939453bo_nitas
bonitoes1038143bo_nitoes
bonitos939733bo_nitos
bonne75124713bo_n_ne
bonnet85524633bonnet_
bonneted1136223bonneted
bonnets94812803bonnets
bonnier94711313bonnier
bonnily1236873bonnily
bonze165119353bo_n_ze
boobie104015293boobi_e
boogie93515993boogi_e
bookie123516003booki_e
boonies93422483boonies
bootie85421153booti_e
boracites1347943boracites
borage93917013bor_age
borane84620213bor_ane
borated104116363bor_ated
borates94823013bor_ates
bordure1035773bordure
bore66051333bor___e
boric98024223bor_i_c
borides10515153bor_ides
boring94724873bor_ing
borings103614243borings
borking144716173borking
born67338413born___
borneol936823borneol
boronic11311163boroni_c
borsht11813503borsht_
borshts1266543borshts
bort65960963bor__t_
borts76735453bor__ts
borty105522833bor__ty
bortz165722203bor__tz
botanise1039643botanise
botanize1948743botanize
bougie93613273bougi_e
bounce104014833boun_ce
bountied1136323bountied
bounties10311393bounties
bounty113411073boun_ty
bourne83714093bourn__e
bourride1144393bourride
bovine11712433bo_vine
bovinity1645023bovinity
bowlike16349473bowlike
bowline123613113bowline
boxlike20267073boxlike
braise84318753b_raise
braize174113113b_raize
braunite1047253braunite
bribe94820773b_r_ibe
bride86425533b_r_ide
brie65837903b_r_i_e
brine75132273b_r_ine
brit66350153b_r_it_
brith104924373b_r_ith
brits76433083b_r_its
britt75732233b_r_itt
bromate11313553bromate
bromide12269583bromide
bromine112915243bromine
bromize20238823bromize
bronze173610923bron_ze
brookite1445503brookite
brownie12178433browni_e
bruise83412873b_ruise
bruit76126723b_ruit_
bruited104110353b_ruited
bruiter93710633b_ruiter
bruits85714453b_ruits
brute75321783b_r_ute
burdie93615023burdi_e
burette939853burette
burkites1436673burkites
burnet84326173burnet_
burnets93813263burnets
burnies94017823burnies
burning104215503burning
burnish1238623burnish
burnt75230323burn_t_
burrito936223burrito
bursate94111203bursate
byrnies12378573byrnies
carnie84421093carni_e
cerite84724873cer_ite
coesite9713623coesite
cognate10312193cognate
cognise1059683cognise
cognize1957683cognize
conine84528553co_nine
connate9315753connate
connive1238993connive
connote9311613connote
conte76633203co_n_te
coontie9311413coontie
corbie103618203corbi_e
cordate10315213cordate
cordites11314603cordites
cornet84436733cornet_
cornets94820573cornets
corniced1368593corniced
cornices12713283cornices
corniche1575923corniche
cornicle1258783cornicle
cornier93017083cornier
cornify1536253cornify
cornily12410853cornily
corning103720123corning
cornuted1137463cornuted
cornuto937023cornuto
coronate103018213coronate
corrie83621213corri_e
corvine122113643corvine
cowrite123612683cowrite
crinite9513633crinite
curite85222943cur_ite
cyanite122710763cyanite
diorite8314913dior_ite
donate73619503do_nate
dormice1237133dormice
dormie9312623dormi_e
dornick1435273dornick
dunite7315013_dunite
dunnite857333dunnite
ebonise939613ebo_nise
ebonites1039223ebo_nites
ebonize1838153ebo_nize
ferrite103312753ferrite
finite9316823_finite
fomite113314073fo_mite
forgive1436193forgive
forint9325023forint_
forints10411833forints
formate123115093formate
fornicate1446083fornicate
fornices1369103fornices
fornix1636033forni_x
forrit91916623forrit_
forte86131463for__te
gahnite1135973gahnite
goonie73615563gooni_e
gordita945093gordita
gothite1146403gothite
granite82017083granite
gunite7414403_gunite
herniae1039043herniae
herniate1148113herniate
hoplite12311073hoplite
hornet94926433hornet_
hornets104113553hornets
hornier103012453hornier
hornily1338283hornily
horning113015003horning
hornist102314823hornist
hornists11208833hornists
hornitos1145393hornitos
hornlike1536503hornlike
hornpipe1542763hornpipe
horste94817413hor_ste
ichnite1245983ichnite
ignite71410573_ignite
iolite63221973io_lite
ionise63516933io_nise
ionize154613863io_nize
ironize16610373ironize
kainite1149543kainite
kernites1269113kernites
kyanite14237313kyanite
laborite10410693labor_ite
lenite6719983_lenite
lignite81310303lignite
loonie64216453looni_e
mannite9312903mannite
marlite92917073marlite
marmite112413993marmite
monie75631653mo_ni_e
monte75829773mo_n_te
moraine9314573moraine
morganite1247423morganite
morning103215043morning
moronity1347333moronity
mortice11711493mortice
mortise9713533mortise
nite45943583___nite
norites74018803nor_ites
oolite63319603_oolite
oorie53026363oor_i_e
ophite11410563_ophite
orate55133303_or_ate
orbit73622053_orbit_
orbited1037733_orbited
orbiter937853_orbiter
orbits84211433_orbits
oreide7311673_oreide
ornis54616773_orni_s
ornithes1136423_ornithes
oroide7311703_oroide
orpine83914483_orpine
orrice81410163_orrice
partite9317133partite
perlite9317313perlite
pinite8321243_pinite
podite93315353po_dite
pointe84619313poin_te
polite83625073po_lite
porcine11312843porcine
pornier93413123pornier
pronate9418873pronate
pyrite11913313pyr_ite
reunite7312713reunite
rite45849453__r_ite
sienite7312713sienite
somite84519373so_mite
sopite84917713so_pite
sorbate9311733sorbate
sordine82515223sordine
sorites73825243sor_ites
sorning83116813sorning
sortie63621983sorti_e
sprite84421773spr_ite
sternite8310543sternite
syenite1039773syenite
tergite8311003tergite
termite9313893termite
ternate7415483ternate
thorite10313443thor_ite
toonie63617993tooni_e
torte55431703tor__te
tortile7313193tortile
townie93312303towni_e
trite54730033_tr_ite
turgite837973turgite
unite54828383__unite
unornate848013unornate
uranite72515693uranite
verite94323443ver_ite
worrit92313313worrit_
worrited1235743worrited
worrits10258683worrits
write85522833_wr_ite
zoisite1635833zoisite
zonate154114923zo_nate

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.1531167915.0
2DLD Change Limit1340273086.03322215.6
3Display Results3083080.1102800.0
 (SQL Overall)1786913086.29628381.7
 
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.