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 “aha” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

323 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
aha61124664(None) 
aa219179951a_a
aah616252961aah
aba512850951aba
aga410447231aga
agha87417301agha
ah513868791ah_
ahi68040231ahi
ahs68644821ahs
ala312463601ala
ama510853301ama
ana39559821ana
ava610139321ava
awa611939671awa
ha510259941_ha
haha107821061haha
sha69837781sha
wha96422071wha
aahs716428562aahs
aal39058672aal
aas310975392aas
ab410674762a_b
abas68642082abas
abba810522642abba
abo59045962abo
abs59356072abs
aby810238062aby
ace59656832ace
ache96829822ache
achy126316092achy
act59557842act
acta69524802acta
ad311975032a_d
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
afar76720782afar
aff95537612aff
aft66849012aft
ag311067462a_g
agar58726412agar
agas55938842agas
age47154332age
aghas97014872aghas
agma77623262agma
ago48845522ago
ags47551662ags
ahead96817052ahead
ahed89536252ahed
ahem97225362ahem
ahis76135382ahis
ahoy101919182ahoy
ai211288392a_i
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
ajar116217702ajar
al210674042a_l
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
alb57342652alb
alba68328332alba
ale36572342ale
alfa77624272alfa
alga57927602alga
all36148232all
alma66333022alma
aloha8513612aloha
alp56641132alp
alpha1049652alpha
als36663022als
alt36467962alt
am411875562a_m
amah98927482amah
amas67746292amas
ami56646802ami
amia66836892amia
amp77541022amp
amu58237322amu
an211879072a_n
anal48037522anal
anas46649862anas
and47244162and
ane37866942ane
anga56831352anga
ani37751172ani
anna45529012anna
anoa45634472anoa
ansa45927772ansa
ant37270782ant
anta46839582anta
any68440482any
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
aqua132813962aqua
ar211379382a_r
arak86929572arak
arb510448422arb
arc510250902arc
are37874572are
area45843392area
arf67453372arf
arhat8327092arhat
aria46245422aria
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
as211083072a_s
asea46327182asea
ash67944602ash
ashy107717352ashy
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
atap66722452atap
ate37059242ate
atma68121772atma
att35454652att
auk76234142auk
aura45836252aura
ave67748702ave
avo68936232avo
aw512563402a_w
away108024222away
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axal116520492axal
axe108239492axe
ay511773892a_y
ayah108022992ayah
aye67151762aye
ays67050292ays
azan136521782azan
azo128233392azo
ba49962342_ba
baa510650422baa
baba88828342baba
bah87755352bah_
baht96740012baht
boa56954032boa
bra56339462bra
caca85528082caca
casa65630862casa
chad105525502chad
chai95929902chai
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
chi86228652chi
chia96026622chia
dacha114812572dacha
dada66422442dada
dah78148982dah_
dahl87019222dahl
dahs88231812dahs
data56026652data
dhak125512032dhak
dhal86719282dhal
eh58339962eh_
epha9310052epha
era35741502era
eta35834192eta
fa510148452_fa
fava106820262fava
gaga66625552gaga
gala55635162gala
gama77035512gama
ghat86435282ghat
ghi77019882ghi
goa47343802goa
haaf106227732haaf
haar77323492haar
had77658762had
hae67364002hae
hag77255742hag
hah910655222hah
hahas117118442hahas
hahs108333362hahs
haj138140602haj
ham86363282ham
hao67251122hao
hap87360052hap
has67372652has
hat67289962hat
haw97153272haw
hay97358772hay
he58151952_he
hi57947582_hi
hm78126732_hm
ho510258272_ho
java147316642java
ka69145082_ka
kaka76518682kaka
kana85928522kana
kapa106021292kapa
kasha124710722kasha
kata85626022kata
kava115819702kava
kea76540912kea
khaf145319602khaf
khan115819142khan
khat116730722khat
khi106318302khi
koa76737772koa
la219261632_la
lahar83114262lahar
lama66635292lama
lava76725422lava
lea37660182lea
ma410060652_ma
mama86231582mama
mana65341942mana
mara67444562mara
masa65034712masa
maya95824582maya
mho86624622mho
moa57249182moa
na28652482_na
nada58022902nada
nah69847002nah_
nala46930392nala
nana46632892nana
napa66927262napa
oba57531552oba
oca56731732oca
oda48133042oda
oh57447002oh_
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oka76926802oka
ora37250832ora
ova66823792ova
pa410456482_pa
paca85132242paca
pacha126518062pacha
pah88853592pah_
papa85827142papa
para65242172para
pasha105417182pasha
pea56657242pea
phat95837862phat
phi86524202phi
pht86030522pht
pia56848032pia
pya87023752pya
qua124821972qua
raga55930812raga
rah68052402rah_
raia46638382raia
raja117918682raja
raya75224822raya
rhea75017432rhea
rho65924832rho
ria36745502ria
rya67622012rya
saga55331172saga
sea36161292sea
sh56828522sh_
shad86230912shad
shag86430562shag
shah105627782shah
sham96436352sham
shat76456592shat
shaw108132552shaw
shay107133342shay
she66837692she
shea76031572shea
shh97121072shh
shwa106014962shwa
shy96728192shy
ska76925862ska
spa55730812spa
ta211662452_ta
tahr75217152tahr
taka87623592taka
tala45938052tala
tapa65129142tapa
taxa116820092taxa
tea37353322tea
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
the67436052the
tho67433962tho
thy97022912thy
twa67721642twa
uh57429852uh_
uta37425582uta
vara75530882vara
vasa76522972vasa
via65636242via
wham125321692wham
whap125119642whap
what105434072what
who95526772who
whoa106615202whoa
why126920012why
ya510251502_ya
yah99046352yah_
yea66445752yea
za1114939202_za
zoa128529992zoa

Search took 1 second 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 Filter178691140840.0802233637.5
2DLD Change Limit140843230.42033533.3
3Display Results3233230.0635127.0
 (SQL Overall)1786913230.563317390.8
 
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.