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

479 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
banians931203(None) 
banian8315381banian_
banyans1237911banyans
anions64123032_anions
avians93711562_avians
bairns86710872ba_irns
banana83213412ban_ana
bananas93312222ban_anas
bandana10179462bandana
bandanas11178572bandanas
bandas95120542banda_s
baning95127832bani_ng
banns75321232ban__ns
bantams1149062bantams
banyan1139482banyan_
banzais1837162banzais
basins85722762basi_ns
basions94213952basions
bunions92210472bunions
cancans11311872cancans
fanions103713072fanions
kalians11310182kalians
kanbans1337722kanbans
magians10310752magians
maniacs114313062maniacs
manias84029032mania_s
mannans93611522mannans
parians93519732parians
radians83013822radians
randans8313212randans
wangans1149502wangans
wanigans1244742wanigans
wanions104011372wanions
abandons1145353abandons
abasias9711013abasia_s
ablins8316193abli_ns
ains46158883_a_i_ns
airns55521033_a_irns
alanins7315803alani_ns
alans55636173_a_lans
alias55834603_alia_s
aliens65619213_aliens
aligns75312953_aligns
amias75831473_amia_s
amins75534323_ami_ns
amnions93710913amnions
anas46649863_an_a_s
anears63717183_anears
angas65827983_anga_s
anginas8310953_anginas
anilins7416793_anilins
anils56326723_ani_ls
animals94111703_animals
animas84418723_animas
animes84719593_animes
animis84615943_animis
animus84211613_animus
anion55028813_anion_
anis45746463_ani__s
anises64826693_anises
anlas55626933_anla_s
annals66415923_annals
annas55824883_anna_s
anoas57226493_anoa_s
antas55432033_anta_s
antiars7314623_antiars
anurans73810553_anurans
anyons94513503_anyons
apian75018333_apian_
arias55438023_aria_s
atmans84413963_atmans
avian84616053_avian_
avions94114393_avions
axions134713483_axions
ayins85321613_ayi_ns
azans146516883_a_zans
baaing94916163baai_ng
baals76122703ba__als
baas66844673ba__a_s
babas96325733ba_ba_s
babies106123653babi_es
babkas146010143babka_s
baboons113211083baboons
bacons104917583ba_cons
badass949293ba_dass
badland1147653badland
badlands1236673badlands
badman113813843badman_
bagass938933ba_gass
bagman114613813bagman_
bagnios1036073bagni_os
bails75933523ba_i_ls
bairn77515533ba_irn_
baits76630583ba_i_ts
baizas173810823ba_izas
baizes174315053ba_izes
baking135626623baki_ng
bakings144312023bakings
balas76937213ba_la_s
baleens938473baleens
baling94829693bali_ng
ballads104212913ballads
ballons93916963ballons
balsams11579013balsams
balsas86417523balsa_s
banal75925993ban_a_l
bancos104713893ban_cos
banda85223103banda__
bandage11311023bandage
bandages12310633bandages
bandaid11310483bandaid
bandanna11174073bandanna
bandannas12163283bandannas
bandeaus1146503bandeaus
banders104324563banders
bandies104124863bandies
banding114921413banding
banditos11347633banditos
bandits103814793bandits
bandogs1138363bandogs
bands85233423ban__ds
bandsaws1444623bandsaws
banes74945583ban__es
bangers104020353bangers
banging114019863banging
bangles103617413bangles
bangs85627773ban__gs
bani65334963bani___
banish111416043bani_sh
banishes131812463banishes
banjax2234763banja_x
banjaxes2443393banjaxes
banjoes16317313banjoes
banjos15378893ban_jos
bankers133919093bankers
banking144621353banking
bankings15489403bankings
bankits133410153bankits
banks115527903ban__ks
banksias1445893banksia_s
banners94018713banners
bannets94013843bannets
banning103818233banning
bans66555143b___ans
bantam10314063banta_m
banteng1046363banteng
bantengs1134593bantengs
banters94623113banters
banties94324763banties
banzai1737653banza_i
baobabs1044443baobabs
barbicans1544483barbicans
barcas101016603barca_s
barchans1588683barchans
bargains1178643bargains
baring95135853bari_ng
barites94322333barites
bariums1139143bariums
barman103519703barman_
barning104320353barni_ng
barns76335143ba__rns
barons85025383ba_rons
barrens94414323barrens
bartisans1165553bartisans
bartizans2053703bartizans
baryons121010473baryons
bashaws15347713bashaws
basics104915123basi_cs
basils85717473basi_ls
basin75026923basi_n_
basinal9310033basinal
basing95427663basi_ng
basion84315853basion_
basis75429863basi__s
bastions10411693bastions
batiks1239373bati_ks
bating95132253bati_ng
batman105214063batman_
batons85519423ba_tons
battens95313263battens
baying125222583bayi_ng
bayman133712703bayman_
bazaars18275883bazaars
bazars174613113ba_zars
beanbags1342863beanbags
beanies93821093beani_es
beaning103820683beani_ng
beans75734693b__eans
bedpans1237173bedpans
begins94415303begi_ns
bemeans1148743bemeans
bemoans1138253bemoans
bendays13327513bendays
benign938313benign_
benisons1037043benisons
benzins1838693benzins
bias64738163b__ia_s
binits85716673bini_ts
bins66548253b__i_ns
biriani945643biriani
birianis1056343birianis
blains84516373blai_ns
bogans95714813b_ogans
bonbons1139333bonbons
boniato947283boniato
boniatos1046673boniatos
boning94223293boni_ng
bonitas939453bonitas
bonitos939733bonitos
brainiacs1343773brainiacs
brainpans1343303brainpans
brains85125473brai_ns
brannigans1352023brannigans
brans75437433b__rans
briars84814823b_riars
brins75533973b_ri_ns
brogans1049663brogans
bruins86014953brui_ns
bunas75126573bun_a_s
bunion83111313bunion_
bunns74718293bun__ns
bunyas11359433bunya_s
burans85019303b_urans
burials93612083burials
burins84221893buri_ns
bwanas1157443bwan_a_s
cabins104418923cabi_ns
caftans12179443caftans
caimans113811783caimans
cains75334303ca_i_ns
cairns85313303ca_irns
callans94518473callans
camions113916133camions
canals84421663can_als
cancan10314103cancan_
canids95118133cani_ds
canikins14219163canikins
canine83826703cani_ne
canines93724033canines
caning94128623cani_ng
cannas84518403canna_s
cannons94412883cannons
canons85522063can_ons
cantals93919573cantals
cantinas102713773cantinas
cantons95221203cantons
canvas113813333canva_s
canvass12376873canvass
canyons124511593canyons
capias10318353capia_s
captans111612053captans
carinas93622403carinas
cations94524143cations
caviars1238623caviars
caymans14349513caymans
conins84327233coni_ns
cyanins122910013cyani_ns
damans94715983da_mans
damiana1046563damiana
damianas1155573damianas
danios7314603dani_os
denials84114133denials
durians839573durians
eonian6311833eonian_
facials123310743facials
facias113415803facia_s
fagins10513863fagi_ns
fangas105017193fanga_s
fanion94514323fanion_
fanons96115213fan_ons
farinas103215233farinas
finials103210153finials
gabions102410053gabions
gains65729513ga_i_ns
gamins94420053gami_ns
ganjahs18104003ganjahs
ganjas14149113ganja_s
gavials1136603gavials
gentians937563gentians
guanins8810013guani_ns
habitans1346623habitans
hangars114313493hangars
hansas94616043hansa_s
hanumans1344953hanumans
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
hazans183411653ha_zans
hazzans18215783hazzans
honans94814503hon_ans
iguanians1042583iguanians
inions64417003_inions
japans1539823ja_pans
jarinas143712183jarinas
jawans1657843ja_wans
kaftans14185353kaftans
kaiaks937043ka_iaks
kains96125643ka_i_ns
kalian10312163kalian_
kanas95326913kan_a_s
kanban1238623kanban_
kantars11310033kantars
kations114013663kations
kinins104014583kini_ns
labials9299873labials
lagans75717783la_gans
lallans74113533lallans
lamias85020613lamia_s
laminas93615873laminas
lanais6316793lan_ais
landaus8310343landaus
laniard868523laniard
laniards967313laniards
laniary1068013laniary
lanitals837723lanitals
lantana739603lantana
lantanas838263lantanas
lapins84520683lapi_ns
lariats7615053lariats
latinas74416463latinas
lauans65113533la_uans
layins93817653layi_ns
linins65922143lini_ns
longans84510813longans
lungans8399053lungans
mafias113913573mafia_s
magian9312833magian_
mains75635113ma_i_ns
maligns1038133maligns
manana84816073man_ana
mananas93414733man_anas
manas76240433man_a_s
manats84623463man_ats
mangas94122923manga_s
mania75634153mania__
maniac103917973mania_c
manics103919933mani_cs
manikins14189723manikins
manilas93915873manilas
maniocs113611443maniocs
manitos9314053manitos
manitus9310923manitus
mannan85413623mannan_
mannas85019803manna_s
mansions1069793mansions
mantas85725363manta_s
manuals9311213manuals
marinas93519383marinas
martians103111613martians
matins84527783mati_ns
mavins115119183mavi_ns
medians103214213medians
menials94015683menials
minions93314623minions
minivans1345413minivans
minyans1237263minyans
naans55815253__naans
naiads739013na_iads
nanas55928633nan_a_s
nandinas936573nandinas
nandins8312003nandins
nanisms938833nanisms
nankins1159053nankins
nans46139403__n_ans
nasions73112383nasions
nations74720563nations
nonfans1037533nonfans
onions64016433_onions
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
pains75138283pa_i_ns
paisans93614753paisans
pandani1039903pandani
pandanus1136433pandanus
pandas95521963panda_s
pangas99921103panga_s
pangens103112063pangens
panics103815363pani_cs
paniers94717333paniers
panini8314273pani_ni
panino8315683pani_no
papains11312363papains
paphians1545593paphians
pariahs123812343pariahs
parian83223963parian_
partans94418283partans
patinas96318523patinas
patins87528783pati_ns
pavans115715593pa_vans
pavins114919663pavi_ns
pians75126963__pians
pinions93413603pinions
qanats154112813qan_ats
radials83614633radials
radian74117273radian_
radiant82817133radiant
radiants9259443radiants
raglans82410133raglans
raias54631123ra_ia_s
rains55140233ra_i_ns
randan7315253randan_
ranids75118703rani_ds
ranis55235833rani__s
ratans63819373ra_tans
rations74123433rations
rattans73411953rattans
ravins94622563ravi_ns
rawins95617623rawi_ns
renins64526453reni_ns
ronions73313343ronions
sabins85521983sabi_ns
sains55639973sa_i_ns
salinas73116093salinas
salpians1036763salpians
sampans112411003sampans
sandals82715203sandals
sangars83116253sangars
sangas75222653sanga_s
sanies63031953sani_es
saning75127643sani_ng
sanious7514103sanious
sanjaks1834963sanjaks
sansars73313913sansars
sapiens9310173sapiens
sarans64224433sa_rans
sarins63932623sari_ns
sasins64923103sasi_ns
satins64930483sati_ns
saurians837763saurians
savins93923133savi_ns
simians959203simians
suntans72111733suntans
swanpans1343423swanpans
taenias7311283taenia_s
tafias93111963tafia_s
tains54936323ta_i_ns
taipans9269553taipans
takins105117403taki_ns
talions7314113talions
tampans113310983tampans
tanists7313653tanists
tankas104613763tanka_s
tannins72813223tannins
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tenias64720073tenia_s
titians72710453titians
unbans81912623_unbans
unions64216753_unions
unmans82211993_unmans
uranias72113813urania_s
vaginas11298813vaginas
valiant10314623valiant
valiants1137793valiants
vandals113211663vandals
vandas103915993vanda_s
vanman1139793vanman_
variant10316803variant
variants1139203variants
varias95019903varia_s
venins93816703veni_ns
wains86930873wa_i_ns
wangan10311223wangan_
wanguns1135023wanguns
wanigan1135213wanigan_
waning103623803wani_ng
wanion93213063wanion_
wannigans1342393wannigans
wantons103713013wantons
xanthans1845693xanthans
xenias133712973xenia_s
zamias174212923zamia_s
zanana153810363zan_ana
zananas16319563zan_anas
zanies153219673zani_es
zanzas1487053zanza_s
zayins18409713zayi_ns

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.403443402.0
2DLD Change Limit1340274796.25321434.0
3Display Results4794790.1702817.6
 (SQL Overall)1786914796.82626178.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.