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 “borne” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

190 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
borne7792679(None) 
bone65949321bo_ne
bonne75124711bonne
borane84620211borane
bore66051331bor_e
born67338411born_
bourne83714091bourne
bane65250422b_ane
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barn66444642barn_
barned95623582barned
barney115314452barney
barns76335142barns
barny105821732barny
barre75929542barre
barye105021492barye
bene66439492b_ene
benne76521122benne
berme96022942berme
bicorne11297552bicorne
bine66650862b_ine
birle75023632birle
birse74517402birse
bocce114313112bocce
boche124216952boche
bode75838752bo_de
bogie89524102bogie
bogle85821682bogle
boing84725552boing
boink115516332boink
boite74426322boite
bole66448692bo_le
bombe115519312bombe
bond75334362bo_nd
boned85133242bo_ned
boner75133082bo_ner
bones76446532bo_nes
boney105227312bo_ney
bong75633412bo_ng
bonk105531712bo_nk
bonnes85621452bonnes
bonnet85524632bonnet
bonnie85314852bonnie
bonny105816622bonny
bony96732082bo_ny
bonze165119352bonze
boon67142172boon_
boons75031912boons
booze164718912booze
bora66141632bor_a
borage93917012borage
boral75831702boral
boranes93720402boranes
boras75938302boras
borate85026152borate
borax145918722borax
bordel94514572bordel
border94419972border
bored85034302bored
boreen8314312boreen
borer75131272borer
bores76448252bores
boric98024222boric
boride9415902boride
boring94724872boring
bork106933822bor_k
borked135117292borked
borks115727702borks
borneol936822borneol
bornite9311182bornite
boron76727142boron
borons85520542borons
bort65960962bor_t
borts76735452borts
borty105522832borty
bortz165722202bortz
boule74828042boule
bounce104014832bounce
bound84819582bound
bourn75518482bourn_
bournes93615022bournes
bourns84114062bourns
bourse84414332bourse
bouse75931852bouse
bovine11712432bovine
bowse105420632bowse
brae65639112b_rae
bree67241262b_ree
bren65629562b_ren
brie65837902b_rie
brine75132272brine
broke116019782broke
brome94421972brome
bronc91714342bronc
bronze173610922bronze
brose75227032brose
burke115122762burke
burn65636422burn_
burned95818962burned
burner83819202burner
burnet84326172burnet
burnie83715412burnie
burns74926772burns
burnt75230322burnt
burse75527252burse
byre95023852byr_e
byrnie11348572byrnie
cone67256962co_ne
core67263112cor_e
corn69945812corn_
cornea84018922cornea
corned95224522corned
cornel84020052cornel
corner84625622corner
cornet84436732cornet
corns76034762corns
cornu75921322cornu
corny106023272corny
corse75036182corse
crone75231332crone
done55747912do_ne
donne65520462donne
dore56353302dor_e
drone65324982drone
erne46727422_erne
force105324272force
fore78351472for_e
forge95126942forge
forme105225992forme
forte86131462forte
gone55639042go_ne
gore55744962gor_e
gorge76423892gorge
gorse65926812gorse
hone77549322ho_ne
horde94623052horde
horn76735612horn_
horned105718702horned
hornet94926432hornet
horns86125332horns
horny115619622horny
horse86132652horse
irone55126362irone
kerne94718212kerne
koine9516482koine
kore85834162kor_e
krone94018732krone
lone45849132lo_ne
lore45850352lor_e
lorn46435252lorn_
morae75831192morae
more67154522mor_e
morn66237562morn_
morns75527442morns
morse76032702morse
none45743172no_ne
one37050912_o_ne
oorie53026362oorie
ore36661832_or_e
orle45630462_orle
pone65747532po_ne
pore66451262por_e
porn65636022porn_
porno75120652porno
porns75527342porns
porny106020192porny
prone75332622prone
sone46649982so_ne
sore47059532sor_e
sorn46641062sorn_
sorned74820042sorned
sorner64720382sorner
sorns55028412sorns
terne56426152terne
tone46953742to_ne
tonne54921432tonne
tore47359322tor_e
torn46044252torn_
torse55833332torse
torte55431702torte
trone55131862trone
upborne11255132upborne
wore77144672wor_e
worn75631752worn_
worse86525262worse
yore76335942yor_e
zone135231082zo_ne

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001901.75030742.9
3Display Results1901900.0464130.4
 (SQL Overall)1786911901.88994595.6
 
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.