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

172 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
bandana1017946(None) 
banana83213411ban_ana
bandanas11178571bandanas
bandanna11174071bandanna
bananas93312222ban_anas
banda85223112band__a
bandage11311022bandage
bandaid11310482bandaid
bandannas12163282bandannas
bandas95120542banda_s
banding114921412banding
bandora1038812bandora
banian8315382banian_
banians9312032banians
banyan1139482banyan_
banyans1237912banyans
lantana739602lantana
manana84816072man_ana
mandala10310212mandala
nandina838912nandina
pandani1039902pandani
randan7315252randan_
randans8313212randans
sardana838642sardana
zanana153810362zan_ana
abandon1045463abandon_
abandons1145353abandons
abundant1145453abundant
andante8311273_andante
angina7413133_angina
anna45529013_an__na
annona648873_annona
arcana8912583_arcana
asana5315483_a_sana
baccara1347143baccara
badass949293ba_dass
badland1147653badland
badman113813843badman_
bagman114613813bagman_
baidarka1542503baidarka
baklava1643103baklava
baklawa1643403baklawa
balata8614683ba_lata
balding114015063balding
banal75925993ban_a_l
band76740923band___
bandaged1337313bandaged
bandager1237703bandager
bandages12310633bandages
bandaging1436063bandaging
bandbox1943763bandbox
bandeau1038523bandeau
bandeaus1146503bandeaus
bandeaux1843293bandeaux
banded105223173band_ed
bander93928223band_er
banders104324563banders
bandied114414303bandied
bandies104124863bandies
bandit93821133band_it
bandito103710043bandito
bandits103814793bandits
bandmate1347973bandmate
bandog1038723band_og
bandogs1138363bandogs
bandoras1138743bandoras
bandore10611633bandore
bands85233433band__s
bandsaw1334803bandsaw
bandsaws1444623bandsaws
bandsman1346753bandsman
bandstand1343933bandstand
bandy114824193band__y
bandying15218073bandying
banging114019863banging
baning95127833ban_ing
banjax2234763banja_x
banking144621353banking
banksia1335943banksia
banning103818233banning
banns75321233ban__ns
bantam10314063banta_m
bantams1149063bantams
banteng1046363banteng
banzai1737653banza_i
banzais1837163banzais
barding113822893barding
barman103519703barman_
barranca1245583barranca
batman105214063batman_
bayman133712703bayman_
benday123810813benda_y
bendays13327513bendays
bending114420893bending
binding113819383binding
bonanza1843843bon_anza
bondage1138253bondage
bonding113318433bonding
bondman1238043bondman_
branding122513683branding
bwana10310243b__wana
cabana103913563ca_bana
cancan10314103cancan_
cancans11311873cancans
candela1089743candela
candent10417363candent
candida114110253candida
canna75919333can__na
cantala94114673cantala
cantata93811813cantata
cantina93417253cantina
canzona1836073canzona
damiana1046563damiana
fandango1342993fandango
fondant11311143fondant
gardant9314463gardant
handax1749583handa_x
handing123518893handing
hariana10310243hariana
indaba935633_indaba
jacana1537933ja_cana
jnana12159043_jn_ana
kanaka9357523kan_aka
kanban1238623kanban_
kanbans1337723kanbans
landau7310613landa_u
landaus8310343landaus
landing92819323landing
landman1038923landman_
lantanas838263lantanas
lindane839033lindane
mananas93414733man_anas
mandalas1139443mandalas
mandate10315573mandate
mandola1039023mandola
manna75522543man__na
mannan85413623mannan_
mannans93611523mannans
mundane1038073mundane
nagana748943na_gana
nana46632903__n_ana
nandin7313033nandin_
nandinas936583nandinas
nandins8312003nandins
paisana94010223paisana
panada94113053pan_ada
panama104213353pan_ama
panda85022613pand__a
pandanus1136433pandanus
pandas95521963panda_s
pandora1039543pandora
pandura1037143pandura
pendant10314853pendant
quandang1943293quandang
sandal73317283sanda_l
sandals82715203sandals
sandarac1145833sandarac
sandbank1544873sandbank
sanding93520603sanding
sandman10310173sandman_
sardanas937823sardanas
tantara72410823tantara
tartana73010193tartana
vanda94515923vand__a
vandal103713833vanda_l
vandals113211663vandals
vandas103915993vanda_s
vanman1139793vanman_
wangan10311233wangan_
wangans1149503wangans
zananas16319563zan_anas
zenana15297983zen_ana

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 Limit1340271726.39020974.5
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.85926052.0
 
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.