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

202 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
banjax223476(None) 
banal75925992ban_al
banda85223102banda_
bandas95120542bandas
banian8315382banian
banjaxed2542352banjaxed
banjaxes2443392banjaxes
banjo143812442banj_o
banjos15378892banjos
bantam10314062bantam
banyan1139482banyan
banzai1737652banzai
ganja131410002ganja_
ganjah17145502ganjah
ganjas14149112ganjas
handax1749582handax
sanjak1735692sanjak
addax1435993_addax
ajar116217703_a_jar
ana39559833_an_a_
anal48037523_an_al
anas46649863_an_as
anear55420323_anear
anga56831353_anga_
angas65827983_angas
anlas55626933_anlas
anna45529013_anna_
annal56520763_annal
annas55824883_annas
annex12310883_annex
anoa45634473_anoa_
anoas57226493_anoas
ansa45927773_ansa_
ansae55720973_ansae
anta46839583_anta_
antae56828293_antae
antas55432033_antas
baa510650423ba__a_
baal67033113ba__al
baas66844673ba__as
baba88828353ba_ba_
babas96325733ba_bas
babka137812913babka_
babkas146010143babkas
bacca111012183bacca_
baccae12119703baccae
badman113813843badman
bagman114613813bagman
baiza164813223baiza_
baizas173810823baizas
balas76937213ba_las
ballad94315323ballad
balneal936573balneal
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
ban58366843ban___
banana83213413banana
bananas93312223bananas
banco94019393ban_co
bancos104713893bancos
band76740913ban__d
bandage11311023bandage
bandaid11310483bandaid
bandana10179463bandana
bandbox1943763bandbox
bandeau1038523bandeau
bandeaux1843293bandeaux
banded105223173banded
bander93928223bander
bandit93821133bandit
bandog1038723bandog
bands85233423ban_ds
bandsaw1334803bandsaw
bandy114824183ban_dy
bane65250433ban__e
baned85436353ban_ed
banes74945583ban_es
bang74837003ban__g
banged104923723banged
banger94423633banger
bangle94018953bangle
bangs85627773ban_gs
bani65334963ban__i
banians9312033banians
baning95127833baning
banish111416043banish
banjaxing2642553banjaxing
banjoes16317313banjoes
bank105835753ban__k
banked135021443banked
banker124222733banker
bankit123617043bankit
banks115527903ban_ks
banned94721343banned
banner84421503banner
bannet84925333bannet
banns75321233ban_ns
bans66555143ban__s
bantams1149063bantams
banter84825333banter
banty106624003ban_ty
banyans1237913banyans
banzais1837163banzais
baobab946403baobab
barbal104016663barbal
barca91319433barca_
barcas101016603barcas
barman103519703barman
basal75722283ba_sal
bashaw14349303bashaw
bateau8810563bateau
bateaux1693883bateaux
batman105214063batman
bayman133712703bayman
bazaar17306403bazaar
bazar163816003ba_zar
beanbag1243943beanbag
benday123810813benday
benzal1739643benzal
binal75323823bin_al
bombax1935753bombax
bonsai838463bonsai
borax145918723b_orax
buna64730723bun_a_
bunas75126573bun_as
bunya103810093bunya_
bunyas11359433bunyas
bwana10310243bwan_a_
bwanas1157443bwan_as
canal75428043can_al
cancan10314103cancan
canna75919333canna_
cannas84518403cannas
cantal84122033cantal
canvas113813333canvas
earwax1664733earwax
fanga96119623fanga_
fangas105017193fangas
fanjet16311393fanjet
galax135314463ga_lax
ganjahs18104003ganjahs
hangar104114513hangar
hansa85416783hansa_
hansas94616043hansas
hapax1739323ha_pax
kana85928533kan_a_
kanas95326913kan_as
kanban1238623kanban
kanji1647453kanj_i
kanjis1735963kanjis
kantar10311153kantar
lanai5319573lan_ai
landau7310613landau
mana65341963man_a_
manas76240433man_as
manat76039993man_at
manga85026203manga_
mangas94122923mangas
mania75634153mania_
maniac103917973maniac
manias84029033manias
manna75522543manna_
mannan85413623mannan
mannas85019803mannas
manta75629913manta_
mantas85725363mantas
manual8313463manual
nana46632903nan_a_
nanas55928633nan_as
ninja1258093ninja_
ninjas1386303ninjas
nontax1348413nontax
panchax2134983panchax
panda85022613panda_
pandas95521963pandas
panga85323533panga_
pangas99921103pangas
paxwax1742953paxwax
qanat144426843qan_at
raja117918683ra_ja_
rajah155711423ra_jah
rajas127317723ra_jas
randan7315253randan
sandal73317283sandal
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sanjaks1834963sanjaks
sansar63613393sansar
syntax1634303syntax
tanga64923693tanga_
tanka93817483tanka_
tankas104613763tankas
unjam1448723_unjam
vanda94515923vanda_
vandal103713833vandal
vandas103915993vandas
vanman1139793vanman
wangan10311223wangan
zanza1378703zanza_
zanzas1487053zanzas

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.376475242.0
2DLD Change Limit1127162025.45320670.5
3Display Results2022020.0603366.7
 (SQL Overall)1786912025.88930343.2
 
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.