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

204 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
ganjah1714550(None) 
ganja131410001ganja_
ganjahs18104001ganjahs
ganjas14149111ganjas
banjax2234762banjax
galah95917632ga_lah
rajah155711422ra_jah
sanjak1735692sanjak
aah616252963_a__ah
ajar116217703_a_jar
almah106917253_almah
amah98927493_a_mah
ana39559833_an_a_
anal48037523_an_al
anas46649863_an_as
anear55420323_anear
anga56831353_anga_
angas65827983_angas
ankh111114413_an_kh
anlas55626933_anlas
anna45529013_anna_
annal56520763_annal
annas55824883_annas
anoa45634473_anoa_
anoas57226493_anoas
ansa45927773_ansa_
ansae55720973_ansae
anta46839583_anta_
antae56828293_antae
antas55432033_antas
ayah108022993_a_yah
banal75925993ban_al
banda85223103banda_
bandas95120543bandas
banian8315383banian
banish111416043banish
banjo143812443banj_o
banjos15378893banjos
bantam10314063bantam
banyan1139483banyan
banzai1737653banzai
canal75428043can_al
cancan10314103cancan
cancha134411613cancha
canna75919333canna_
cannas84518403cannas
cantal84122033cantal
canvas113813333canvas
casbah1337903casbah
danish101513793danish
fanga96119623fanga_
fangas105017193fangas
fanjet16311393fanjet
gadje1457743gadj_e
gadjo1436913gadj_o
gaga66625553ga_ga_
gagman103811243gagman
gaijin1445983gaijin
gainsay1144043gainsay
gala55635163ga_la_
galahs105512673ga_lahs
galas65731643ga_las
galax135314463ga_lax
galea64722933galea_
galeae74717453galeae
galeas74618513galeas
galosh1038563galosh
galyac1235973galyac
galyak1445333galyak
gama77035523ga_ma_
gamas85431363ga_mas
gamay116419113ga_may
gamba106018513gamba_
gambas115817513gambas
gamma106116103gamma_
gammas115714693gammas
gan48060133gan___
ganache1346213ganache
gander84322763gander
gane55145303gan__e
ganef96322463gan_ef
ganefs10489203ganefs
ganev95513863gan_ev
ganevs10456913ganevs
gang66031973gan__g
ganged94619193ganged
ganger83721463ganger
gangly113911583gangly
gangs76222573gan_gs
gangue81310573gangue
gangway1544233gangway
gannet74321853gannet
ganof95420363gan_of
ganofs104010293ganofs
ganoid8314443ganoid
gantry103810113gantry
garda7316763garda_
gardai839663gardai
garish104516923garish
garnish111610843garnish
garth94720223ga_rth
gasbag1035413gasbag
gash86833023ga__sh
gasman92911743gasman
gateau778113gateau
gavial10310083gavial
gayal9312713ga_yal
gaydar1135503gaydar
gazar154612983ga_zar
genial74917613genial
genoa64315823genoa_
genoas74013623genoas
genua64614153genua_
gerah9315303g_erah
gingal81010153gingal
gnar56021383g_n_ar
gnash9449833g_nash
gnat56034433g_n_at
gnaw86515743g_n_aw
goanna736653goanna_
goannas836223goannas
gonad75216053gon_ad
gonia64117533gonia_
gonoph1235403gonoph
grana65722093gran_a_
grandad1038453grandad
grandam1139393grandam
guanay1037913guan_ay
gunman9299453gunman
hallah124115403hallah
halvah15499833halvah
hamzah23135563hamzah
handax1749583handax
hangar104114513hangar
hansa85416783hansa_
hansas94616043hansas
jarrah1636683jarrah
kana85928533kan_a_
kanas95326913kan_as
kanban1238623kanban
kanji1647453kanj_i
kanjis1735963kanjis
kantar10311153kantar
kasbah1535183kasbah
lanai5319573lan_ai
landau7310613landau
mana65341963man_a_
manas76240433man_as
manat76039993man_at
manga85026203manga_
mangas94122923mangas
mania75634153mania_
maniac103917973maniac
manias84029033manias
manna75522543manna_
mannan85413623mannan
mannas85019803mannas
manta75629913manta_
mantas85725363mantas
manual8313463manual
matsah1138233matsah
matzah2035963matzah
mynah13569563myn_ah
nah69847003__n_ah
nana46632903nan_a_
nanas55928633nan_as
ninja1258093ninja_
ninjas1386303ninjas
panda85022613panda_
pandas95521963pandas
panga85323533panga_
pangas99921103pangas
pardah123412823pardah
pariah114320583pariah
pujah17478543_pujah
punkah15347093punkah
qanat144426843qan_at
raja117918683ra_ja_
rajahs16497663ra_jahs
rajas127317723ra_jas
ranch105019793ran_ch
randan7315253randan
rayah116013503ra_yah
sandal73317283sandal
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sangh95517453san_gh
sanjaks1834963sanjaks
sansar63613393sansar
sunnah9369353sunnah
tanga64923693tanga_
tanka93817483tanka_
tankas104613763tankas
unjam1448723_unjam
vanda94515923vanda_
vandal103713833vandal
vandas103915993vandas
vanish121513213vanish
vanman1139793vanman
wallah124011993wallah
wangan10311223wangan
zanza1378703zanza_
zanzas1487053zanzas

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162045.81019400.3
3Display Results2042040.0633238.1
 (SQL Overall)1786912046.26628517.6
 
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.