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

211 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
bagnios103607(None) 
bagnio937521bagnio_
agios65919862_ag_ios
amnios84912522_amnios
baggies113814852baggies
bagwigs1432822bagwigs
bancos104713892ba_ncos
banjos15378892ba_njos
barrios9310772barrios
danios7314602da_nios
adagios945513adag_ios
adios65822863_a_dios
aggies83515513_aggies
aggros836553_aggros
agings86312673_agings
agio57828453_ag_io_
agnails837003_agnails
agnize16329563_agnize
agnizes17328843_agnizes
agonies83016623_agonies
agrias74315393_agrias
alnicos985533_alnicos
amnio75218053_amnio_
amnion84812053_amnion
amnions93710913_amnions
anglos74413913_anglos
anils56326723_a_nils
anion55028813_a_nion
anions64123033_a_nions
anis45746463_a_ni_s
audios72312283_audios
babies106123653ba_bies
baboos103517013ba_boos
baddies114017873baddies
badness1039573badness
baffies153612943baffies
bagass938933bag_ass
bagels95712313bag_els
bagfuls1334753bagfuls
baggers113915693baggers
baggie102912193baggi_e
baggier113611643baggier
baggiest123011753baggiest
baggily1436043baggily
bagging123316983bagging
baggings13307523baggings
baglike14338943baglike
bagpipe1453113bagpipe
bagpipes1543403bagpipes
bags76645503bag___s
baguets1037483baguets
bagwig1343083bagwi_g
bailies94120203bailies
bails75933523ba__ils
baits76630583ba__its
bakings144312023bakings
baldies105317703baldies
ballies93725743ballies
bambinos1443873bambinos
bamboos1348753bamboos
banco94019393ba_nco_
bandas95120543ba_ndas
bandies104124863bandies
banditos11347633banditos
bandits103814793bandits
bandog1038723ba_ndog
bandogs1138363ba_ndogs
bands85233423ba_n_ds
banes74945583ba_n_es
bangers104020353bangers
banging114019863banging
bangkok1341793bangkok
bangkoks1441843bangkoks
bangles103617413bangles
bangs85627773ba_n_gs
bani65334963ba_ni__
banian8315383ba_nian
banians9312033ba_nians
baning95127833ba_ning
banish111416043ba_nish
banjo143812443ba_njo_
banjoes16317313ba_njoes
bankits133410153bankits
banks115527903ba_n_ks
banners94018713banners
bannets94013843bannets
banning103818233banning
banns75321233ba_n_ns
bans66555143ba_n__s
banties94324763banties
barbies114519593barbies
bargains1178643bargains
barneys12569563barneys
barnier93213673barnier
barniest104815053barniest
barning104320353barning
barns76335143barn__s
baronies10315023baronies
barrio8312573barrio_
basics104915123ba_sics
basils85717473ba_sils
basins85722763ba_sins
basion84315853ba_sion
basions94213953ba_sions
basis75429863ba_si_s
bassos85313703ba_ssos
bastion9312473bastion
bastions10411693bastions
bathos116215633ba_thos
batiks1239373ba_tiks
battiks1337143battiks
bawdies134613393bawdies
bawties124214313bawties
bayamos1434663bayamos
bazoos173212623ba_zoos
beanies93821093beanies
beanos85516513bean_os
beatniks1444043beatniks
begins94415303beg_ins
begonias1146263begonias
begrims1276763begrims
bennies93917313bennies
bennis84314803benni_s
bentos86218303b_entos
biggies113813523biggies
biggins113410693biggins
bigness1038193bigness
bigos85020013big__os
bigwigs1443003bigwigs
bingos95514793b_ingos
binits85716673b_inits
bionics114310873bionics
bios66335323b___ios
blinis85313683blini_s
bogies94724313bog_ies
bongos95316653b_ongos
bonitos939733b_onitos
boonies93422483boonies
brinies93317913brinies
brios74725723b__rios
broncos11188073broncos
buggies114613813buggies
buncos104011593b_uncos
bunion83111313b_union
bunions92210473b_unions
bunkos124210323b_unkos
bunnies94415003bunnies
burnies94017823burnies
byrnies12378573byrnies
canids95118133ca_nids
cansos84915383ca_nsos
cantos84826973ca_ntos
carnies94123963carnies
casinos93512833casinos
catnips1195893catnips
dagos76419443dag__os
daimios1035753daimios
danio6319783da_nio_
fagins10513863fag_ins
fanion94514323fa_nion
fanions103713073fa_nions
fannies103415643fannies
fanos85926503fa_n_os
fugios1037583fug_ios
haggis11209513haggi_s
jaggies163311083jaggies
kainits1137763kainits
ladinos8389963ladinos
latinos73613803latinos
lignins84010493lignins
magics115311613mag_ics
magnetos1146263magnetos
magnets10311143magnets
magnify1634533magnify
magnums1234683magnums
magpies12310363magpies
mangos94319333ma_ngos
manias84029033ma_nias
manics103919933ma_nics
manioc103914823ma_nioc
maniocs113611443ma_niocs
manitos9314053ma_nitos
manos74933623ma_n_os
nannies73015203nannies
pagings114411063pagings
panics103815363pa_nics
pantos85222743pa_ntos
patios85221783pa_tios
paynims1434973paynims
radios74018673ra_dios
raggies93214733raggies
ragis66325603rag_i_s
ranids75118703ra_nids
ranis55235833ra_ni_s
ratios64922673ra_tios
sagos66123873sag__os
sanies63031953sa_nies
sanious7514103sa_nious
santos64421833sa_ntos
segnos73610443segn_os
signior835043signior
signiors944923signiors
taenias7311283taenias
tangos74216303ta_ngos
tannins72813223tannins
tawnies102812503tawnies
vaginas11298813vaginas
wanion93213063wa_nion
wanions104011373wa_nions
yagis95416573yag_i_s
zanies153219673za_nies

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.406440125.6
2DLD Change Limit1340272116.12621878.4
3Display Results2112110.0762776.3
 (SQL Overall)1786912116.60827041.6
 
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.