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

244 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
banzai173765(None) 
banzais1837161banzais
baiza164813222baiza_
baizas173810822baizas
banal75925992ban_al
banda85223102banda_
bandaid11310482bandaid
bandas95120542bandas
bani65334952ban__i
banian8315382banian
banjax2234762banjax
bantam10314062bantam
banyan1139482banyan
bazar163816002ba_zar
benzal1739642benzal
bonsai838462bonsai
lanai5319572lan_ai
zanza1378702zanza_
zanzas1487052zanzas
ana39559823_an_a_
anal48037523_an_al
anas46649863_an_as
anear55420323_anear
anga56831353_anga_
angas65827983_angas
ani37751173_an__i
animi74016663_animi
anlas55626933_anlas
anna45529013_anna_
annal56520763_annal
annas55824883_annas
anoa45634473_anoa_
anoas57226493_anoas
ansa45927773_ansa_
ansae55720973_ansae
anta46839583_anta_
antae56828293_antae
antas55432033_antas
anti45536363_an_ti
assai5711543_assai
azan136521783_a_zan
baa510650423ba__a_
baal67033113ba__al
baas66844673ba__as
baba88828353ba_ba_
babas96325733ba_bas
babka137812913babka_
babkas146010143babkas
bacca111012183bacca_
baccae12119703baccae
badman113813843badman
bagman114613813bagman
baize164717393baiz_e
baizes174315053baizes
balas76937213ba_las
ballad94315323ballad
balneal936573balneal
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
ban58366833ban___
banana83213413banana
bananas93312223bananas
banco94019393ban_co
bancos104713893bancos
band76740903ban__d
bandage11311023bandage
bandana10179463bandana
bandeau1038523bandeau
banded105223173banded
bander93928223bander
bandit93821133bandit
bandog1038723bandog
bands85233423ban_ds
bandsaw1334803bandsaw
bandy114824183ban_dy
bane65250423ban__e
baned85436353ban_ed
banes74945583ban_es
bang74836993ban__g
banged104923723banged
banger94423633banger
bangle94018953bangle
bangs85627773ban_gs
bangtail1144353bangtail
banians9312033banians
baning95127833baning
banish111416043banish
banjo143812443ban_jo
banjos15378893banjos
bank105835743ban__k
banked135021443banked
banker124222733banker
bankit123617043bankit
banks115527903ban_ks
banksia1335943banksia
banned94721343banned
banner84421503banner
bannet84925333bannet
banns75321233ban_ns
bans66555133ban__s
banshie12129543banshie
bantams1149063bantams
banter84825333banter
banty106624003ban_ty
banyans1237913banyans
baobab946403baobab
barbal104016663barbal
barca91319433barca_
barcas101016603barcas
bargain1079063bargain
barmaid1238203barmaid
barman103519703barman
basal75722283ba_sal
bashaw14349303bashaw
basmati1148233basmati
bassi77019323ba_ssi
bateau8810563bateau
batman105214063batman
bayman133712703bayman
bazaar17306403bazaar
bazars174613113ba_zars
bazoo163815673ba_zoo
beanbag1243943beanbag
benday123810813benday
benni74715363ben_ni
benzin1738933benzin
benzoic2045033benzoic
benzoin1846263benzoin
benzol1756993benzol
benzyl2034163benzyl
binal75323823bin_al
bindi85617013bin_di
bonaci10310963bonaci
bonanza1843843bonanza_
bonanzas1943113bonanzas
bonze165119353bonz_e
bonzer175313673bonzer
bonzes175116103bonzes
borzoi1736623borzoi
brantail1046893brantail
braza165214253braza_
brazas175812433brazas
buna64730723bun_a_
bunas75126573bun_as
bunya103810093bunya_
bunyas11359433bunyas
bwana10310243bwan_a_
bwanas1157443bwan_as
canal75428043can_al
cancan10314103cancan
canna75919333canna_
cannas84518403cannas
cantal84122033cantal
canthi11310973canthi
canvas113813333canvas
canzoni1836153canzoni
centai84814783centai
fanga96119623fanga_
fangas105017193fangas
fantail10310233fantail
ganja131410003ganja_
ganjah17145503ganjah
ganjas14149113ganjas
gardai839663gardai
gazar154612983ga_zar
hamza19139773hamza_
hamzah23135563hamzah
hamzas20119013hamzas
handax1749583handax
hangar104114513hangar
hansa85416783hansa_
hansas94616043hansas
hazan173813613ha_zan
hazzan17236803hazzan
kana85928523kan_a_
kanas95326913kan_as
kanban1238623kanban
kanji1647453kan_ji
kantar10311153kantar
kanzu1847593kanz_u
kanzus1944603kanzus
kwanza2232473kwanza_
kwanzas2342053kwanzas
lanais6316793lan_ais
landau7310613landau
laogai735983laogai
lazar144113643la_zar
mana65341943man_a_
manas76240423man_as
manat76039983man_at
manga85026193manga_
mangas94122923mangas
mania75634143mania_
maniac103917973maniac
manias84029033manias
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
manta75629903manta_
mantas85725363mantas
manual8313463manual
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
nana46632893nan_a_
nanas55928633nan_as
nazi136219873na_z_i
panda85022613panda_
pandani1039903pandani
pandas95521963pandas
panga85323533panga_
pangas99921103pangas
panini8314273panini
panzer174213233panzer
qanat144426843qan_at
randan7315253randan
rani46640103ran__i
sandal73317283sandal
sandhi1038193sandhi
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sanjak1735693sanjak
sansar63613393sansar
sansei63411903sansei
stanza1537073stanza_
stanzaic1943363stanzaic
stanzas1636363stanzas
tanga64923693tanga_
tanka93817483tanka_
tankas104613763tankas
tanuki1034913tanuki
tarzan152910753tarzan
tazza1338083tazza_
tazzas1436273tazzas
unai44824783_un_ai
vanda94515923vanda_
vandal103713833vandal
vandas103915993vandas
vanman1139793vanman
wangan10311223wangan
yanqui1843383yanqui
zaikai1943713zaikai

Search took 6 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 Limit1127162445.65619928.6
3Display Results2442440.0803050.0
 (SQL Overall)1786912445.87630410.3
 
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.