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

232 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
bagnio93752(None) 
bagnios1036071bagnios
agio57828452_ag_io
amnio75218042_amnio
baggie102912192baggie
bagwig1343082bagwig
banco94019392ba_nco
bani65334952ba_ni_
banjo143812442ba_njo
barrio8312572barrio
danio6319782da_nio
adagio847663adag_io
again65218113_again
aggie73415013_aggie
aggro738003_aggro
agin56132713_ag_in
aging77026353_aging
agios65919863_ag_ios
agnail739523_agnail
agnize16329563_agnize
ago48845523_ag__o
agonic93515143_agonic
agria65517143_agria
alnico877943_alnico
amino75425493_amino
amnia75918633_amnia
amnic95516233_amnic
amnion84812043_amnion
amnios84912513_amnios
anglo65215363_anglo
ani37751173_a_ni_
anil46437433_a_nil
anion55028813_a_nion
anis45746463_a_nis
audio62917103_audio
baaing94916163baaing
baalim1038473baalim
baboo94319503ba_boo
baddie104114033baddie
badging123712793badging
bag67059223bag___
bagass938933bagass
bagel85116793bag_el
bagels95712313bagels
bagful1237213bagful
bagged114519903bagged
bagger104619203bagger
baggier113611643baggier
baggies113814853baggies
baggily1436043baggily
bagging123316983bagging
baggy125615683bag_gy
baglike14338943baglike
bagman114613813bagman
bagmen115412533bagmen
bagpipe1453113bagpipe
bags76645503bag__s
baguet9316103baguet
bagwigs1432823bagwigs
bail65042803ba__il
bailie83818363bailie
bait66556003ba__it
baking135626623baking
baling94829693baling
bambino1336473bambino
bamboo12310013bamboo
ban58366833ba_n__
banal75925993ba_nal
bancos104713893ba_ncos
band76740903ba_n_d
banda85223103ba_nda
bandit93821133bandit
bandito103710043bandito
bandog1038723ba_ndog
bands85233423ba_nds
bandy114824183ba_ndy
bane65250423ba_n_e
baned85436353ba_ned
banes74945583ba_nes
bang74836993ba_n_g
banged104923723banged
banger94423633banger
banging114019863banging
bangkok1341793bangkok
bangle94018953bangle
bangs85627773ba_ngs
banian8315383ba_nian
baning95127833ba_ning
banish111416043ba_nish
banjos15378893ba_njos
bank105835743ba_n_k
bankit123617043bankit
banks115527903ba_nks
banned94721343banned
banner84421503banner
bannet84925333bannet
banning103818233banning
banns75321233ba_nns
bans66555133ba_n_s
banty106624003ba_nty
barbie105018353barbie
bardic11312923bardic
bargain1079063bargain
barging114018483barging
baric96125693ba_ric
baring95135853baring
barmie103816393barmie
barn66444643barn__
barned95623583barned
barney115314453barney
barnier93213673barnier
barning104320353barning
barns76335143barn_s
barny105821733barn_y
barrios9310773barrios
basic96220523ba_sic
basil75122273ba_sil
basin75026923ba_sin
basing95427663basing
basins85722763basins
basion84315853ba_sion
basis75429863ba_sis
bassi77019323bassi_
basso76017283ba_sso
bastion9312473bastion
batik11614733ba_tik
bating95132253bating
battik1238093battik
bawtie113812143bawtie
bayamo1335603bayamo
baying125222583baying
bazoo163815673ba_zoo
beanie83618593beanie
beano75421553bean_o
beatnik1344863beatnik
begin85117353beg_in
begins94415303begins
begonia1047213begonia
begrim11118333begrim
benni74715363benni_
bennis84314803bennis
bento75922953b_ento
biggie103810933biggie
biggin103710603biggin
bigwig1333343bigwig
bingo86020093b_ingo
binit76431583b_init
bio57846073b___io
bionic103614573bionic
blini75519273blini_
blinis85313683blinis
bogie89524103bog_ie
bongo85720943b_ongo
bonito8313433b_onito
bonnie85314853bonnie
brio65432493b__rio
bronco10179493bronco
bunco94616083b_unco
bunion83111313b_union
bunko115514513b_unko
burnie83715413burnie
byrnie11348573byrnie
caging105321023caging
canid85526343ca_nid
cannie83819363cannie
canso75019403ca_nso
canto74931013ca_nto
cardio9915673cardio
carnie84421093carnie
casino84317553casino
catnip1097963catnip
dago65725083dag__o
daimio937463daimio
danios7314603da_nios
fagin9216573fag_in
fagins10513863fagins
fanion94514323fa_nion
fano75831683fa_n_o
fugio9310923fug_io
gaging94718403gaging
garni6315703garni_
haggis11209513haggis
kainit10414483kainit
kaonic1238763kaonic
ladino73615123ladino
latino64120473latino
lignin74911193lignin
magi76329523mag_i_
magic105818653mag_ic
magnet9320663magnet
magneto1046743magneto
magnify1634533magnify
magnum1136733magnum
magpie1139093magpie
mango85724313ma_ngo
mania75634143ma_nia
manic94629433ma_nic
manioc103914823ma_nioc
manito8518693ma_nito
mano66536793ma_n_o
nannie63713223nannie
paging104020403paging
panic93923903pa_nic
panino8315683pa_nino
panto76129413pa_nto
patio74426353pa_tio
paynim1337363paynim
pernio8513143pernio
radio64922493ra_dio
ragi56032283rag_i_
raging85126433raging
ragis66325603rag_is
rani46640103ra_ni_
ranid66429333ra_nid
ranis55235833ra_nis
ratio55227583ra_tio
sago56332673sag__o
santo56227283sa_nto
segni63712483segni_
segno64814743segn_o
signior835043signior
taenia6313193taenia
tango66921173ta_ngo
tannic82811473tannic
tannin62613923tannin
tanto55724943ta_nto
vagi86719363vag_i_
vagina102710933vagina
waging114318383waging
wanion93213063wa_nion
yagi86922243yag_i_
yagis95416573yag_is

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.1401276364.3
2DLD Change Limit1127162326.20318171.2
3Display Results2322320.0603866.7
 (SQL Overall)1786912326.40327907.4
 
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.