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

133 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
ganjahs1810400(None) 
ganjah17145501ganjah_
ganjas14149111ganja_s
galahs105512682ga_lahs
ganja131410002ganja__
rajahs16497662ra_jahs
sanjaks1834962sanjaks
aahs716428563_a__ahs
almahs118611613_almahs
amahs107819063_a_mahs
anas46649863_an_a_s
anears63717183_anears
angas65827983_anga_s
ankhs12116723_an_khs
anlas55626933_anla_s
annals66415923_annals
annas55824883_anna_s
anoas57226493_anoa_s
antas55432033_anta_s
ayahs116813523_a_yahs
bandas95120543banda_s
banians9312033banians
banjax2234763banja_x
banjaxes2443393banjaxes
banjoes16317313banjoes
banjos15378893banj_os
bantams1149063bantams
banyans1237913banyans
banzais1837163banzais
canals84421673can_als
cancans11311873cancans
canchas143212403canchas
cannas84518403canna_s
cantals93919573cantals
canvas113813333canva_s
canvass12376873canvass
casbahs1436463casbahs
fangas105017193fanga_s
fanjets1734803fanjets
gainsays1243513gainsays
galah95917643ga_lah_
galas65731643ga_la_s
galeas74618513galea_s
galyacs1335273galyacs
galyaks1534623galyaks
gamas85431363ga_ma_s
gamays126310913ga_mays
gambas115817513gamba_s
gammas115714693gamma_s
ganache1346223ganache
ganaches1437433ganaches
ganders93521703ganders
ganefs10489203gan_efs
ganevs10456913gan_evs
gangers94418603gangers
gangs76222573gan__gs
gangues9149753gangues
gangways1643733gangways
gannets83811443gannets
ganofs104010293gan_ofs
ganoids939333ganoids
garths104111503ga_rths
gasbags1135473gasbags
gateaus866333gateaus
gavials1136603gavials
gayals1039513ga_yals
gaydars1235803gaydars
gazars164811553ga_zars
genoas74013623genoa_s
gerahs1039413g_erahs
gingals9109313gingals
gnars66718853g_n_ars
gnash9449833g_n_ash
gnats65217713g_n_ats
gnaws96311143g_n_aws
goannas836223goanna_s
gonads84511733gon_ads
gonophs1344453gonophs
grandads1136553grandads
grandams1237123grandams
guanays1134953guan_ays
hallahs133912463hallahs
halvahs16417533halvahs
hamzahs24134373hamzahs
hangars114313493hangars
hansas94616043hansa_s
jarrahs1735453jarrahs
kanas95326913kan_a_s
kanbans1337723kanbans
kanjis1735963kanj_is
kantars11310033kantars
kasbahs1634363kasbahs
lanais6316793lan_ais
landaus8310343landaus
manas76240433man_a_s
manats84623463man_ats
mangas94122923manga_s
maniacs114313063maniacs
manias84029033mania_s
mannans93611523mannans
mannas85019803manna_s
mantas85725363manta_s
manuals9311223manuals
matsahs1236563matsahs
matzahs2134483matzahs
mynahs14416443myn_ahs
nanas55928633nan_a_s
ninjas1386303ninja_s
pandas95521963panda_s
pangas99921103panga_s
pardahs13289673pardahs
pariahs123812343pariahs
pujahs18404943_pujahs
punkahs16284783punkahs
qanats154112813qan_ats
rajah155711423ra_jah_
rajas127317723ra_ja_s
randans8313213randans
rayahs12579193ra_yahs
sandals82715203sandals
sangars83116253sangars
sangas75222653sanga_s
sanghs105312063san_ghs
sanjak1735693sanja_k
sansars73313913sansars
sunnahs10326593sunnahs
tankas104613763tanka_s
unjams1555703_unjams
vandals113211663vandals
vandas103915993vanda_s
wallahs13409473wallahs
wangans1149503wangans
zanzas1487053zanza_s

Search took 8 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 Limit1340271336.86019537.5
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.31224438.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.