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

191 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
bazaar1730640(None) 
bazaars18275881bazaars
bazar163816001baz_ar
bazars174613112bazars
bezoar1736912bezoar
gazar154612982gaz_ar
lazar144113642laz_ar
afar76720783_a_far
agar58726413_a_gar
ajar116217703_a_jar
alar46340073_a_lar
altar55520643_altar
anear55420323_anear
attar56516693_attar
aurar54420253_aurar
avatar937523_avatar
azan136521783_az_an
azans146516883_azans
baa510650423b__aa_
baaed85218163ba_aed
baal67033113b__aal
baals76122703ba_als
baas66844673b__aas
baba88828353ba_ba_
babas96325733ba_bas
babier103515573babier
babka137812913babka_
babkas146010143babkas
bacalao1146613bacalao
bacca111012183bacca_
baccae12119703baccae
baccara1347153baccara
backer144525533backer
badass949293badass
badder103817513badder
badger105415083badger
badman113813843badman
bagass938933bagass
bagger104619203bagger
bagman114613813bagman
bahadur1342603bahadur
bailer85425253bailer
bailor83412603bailor
baiter84422563baiter
baiza164813223baiza_
baizas173810823baizas
baker115629543ba_ker
balas76937213ba_las
balata8614683balata
balatas9311833balatas
balder95318863balder
baler75635273ba_ler
balker124519163balker
ballad94315323ballad
baller83825203baller
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banal75925993ba_nal
banana83213413banana
bananas93312223bananas
banda85223113banda_
bandas95120543bandas
bander93928223bander
banger94423643banger
banian8315383banian
banjax2234763banjax
banker124222733banker
banner84421503banner
bantam10314063bantam
banter84825343banter
banyan1139483banyan
banzai1737653banzai
banzais1837163banzais
baobab946403baobab
bar58070553b___ar
barbal104016663barbal
barber104419323barber
barca91319433barca_
barcas101016603barcas
barer74535803ba_rer
barker124822863barker
barman103519703barman
barter85525383barter
barware12610703barware
basal75722283ba_sal
basalt83519583basalt
baser74828923ba_ser
bashaw14349303bashaw
basher115123813basher
basilar937303basilar
bastard103012423bastard
baster85333603baster
bateau8810573bateau
bather115322513bather
batman105214063batman
batter84928883batter
bawler114315053bawler
bayamo1335603bayamo
bayard124411663bayard
bayman133712703bayman
bazoo163815673baz_oo
bazoos173212623bazoos
bear66844643b__ear
beggar10328223beggar
bezant17814543bezant
bezazz1543983bezazz
bezoars1836793bezoars
bizarre1844103bizarre
bizarro1843333bizarro
blazer174414023blaz_er
blear75918683b_lear
boar66134293b__oar
bolar75123473b_olar
boxcar1734753boxcar
boyar106013763b_oyar
braza165214253braz_a_
brazas175812433braz_as
brazer174917533braz_er
brazier183911473brazier
briar75718153b_riar
bulbar1039583bulbar
bursar85413253bursar
busbar1038453busbar
buzzard1844273buzzard
buzzer16379113buzzer
byzant2096813byzant
caesar8410933caesar
calamar1149293calamar
calcar10312753calcar
caviar11310163caviar
czar156013133_cz_ar
damar84117743da_mar
dammar11438903dammar
darbar959953darbar
gaydar1135503gaydar
gazabo1834833gazabo
gazars164811553gazars
gazer155720073gaz_er
haar77323493__haar
hangar104114523hangar
hazan173813613haz_an
hazans183411653hazans
hazard1938403hazard
hazer174820233haz_er
hazier184712403hazier
hazmat20312263hazmat
hazzan17236803hazzan
izar136616013_iz_ar
jacamar1844323jacamar
jaguar1435283jaguar
jazzer21376503jazzer
kabar114815553ka_bar
kantar10311153kantar
labara83712893labara
lahar83114263la_har
lascar868573lascar
lazars153812393lazars
lazier154214613lazier
maar66025063__maar
makar115614973ma_kar
malar76424443ma_lar
mazard1838763mazard
mazer165722423maz_er
mazier175013063mazier
mazzard1844463mazzard
navar83912733na_var
palmar104113463palmar
patamar1147093patamar
pazazz1554023pazazz
radar61316723ra_dar
razer144824273raz_er
razor143012603raz_or
saggar84010853saggar
salaam8711013salaam
samara8313853samara
sambar103914163sambar
sangar73617693sangar
sansar63613393sansar
sardar73013173sardar
sarsar63011843sarsar
satara6315533satara
sizar145214993siz_ar
talar56225383ta_lar
tartar63214753tartar
tatar56122063ta_tar
tazza1338083tazza_
tazzas1436283tazzas
tzar136315373_tz_ar
valvar12388653valvar
zaffar21385043zaffar

Search took 10 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.763234195.3
2DLD Change Limit1127161918.55013183.2
3Display Results1911910.0603183.3
 (SQL Overall)1786911919.37319064.4
 
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.