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

319 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
ahis7613538(None) 
ahi68040231ahi_
ahs68644821ah_s
ais39083571a_is
amis66445321amis
anis45746461anis
aphis105917131aphis
axis116127911axis
chis95933311chis
ghis85020161ghis
his66359501_his
khis117017981khis
phis95724901phis
this76027381this
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abos67734412abos
abris75722602abris
abs59356072a_bs
abys97221882abys
aces67645092aces
aches106132292aches
acid77533392acid
acids87121002acids
acts66929862acts
adds67622452adds
adios65822862adios
adit56443652adit
adits66523712adits
ados57633512ados
ads49755732a_ds
aegis6316782aegis
agas55938842agas
ages55844592ages
aghas97014872aghas
agin56132712agin
agio57828452agio
agios65919862agios
agism84614062agism
agist66325582agist
ags47551662a_gs
ah513868792ah__
aha611246642ah_a
ahed89536252ahed
ahem97225362ahem
ahimsa1134782ahimsa
ahing98928342ahing
ahoy101919182ahoy
ai211288392a_i_
aid49269072a_id
aids57846352aids
ail37171042a_il
ails45654712ails
aim57858212a_im
aims67738182aims
ain37579092a_in
ains46158882ains
air38058392a_ir
airs46447422airs
ait38093902a_it
aits46355532aits
akin86328032akin
alas46358122alas
albs68628572albs
ales47067102ales
alias55834602alias
alif76242142alif
alifs86121262alifs
alist56136782alist
alit46155692alit
alls46740922alls
alms65834922alms
alps65529242alps
als36663022a_ls
alts46639902alts
amas67746292amas
ami56646812ami_
amia66836902amia
amias75831472amias
amid77036342amid
amids85627512amids
amie66339852amie
amies76837692amies
amin66042252amin
amins75534322amins
amir65129752amir
amirs75924922amirs
amiss75823072amiss
amps86230342amps
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
ani37751172ani_
anil46437432anil
anils56326722anils
anise55129702anise
antis55033312antis
ants47243472ants
anus47131112anus
apes66047432apes
aphid115515392aphid
aphids125110842aphids
apish105116632apish
apos65433822apos
apps86319692apps
apsis75718292apsis
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
aria46245422aria
arias55438022arias
arid57642712arid
aril45843022aril
arils58732202arils
arise56436432arise
arks85936872arks
arms66137492arms
arris56824682arris
ars37670932a_rs
arsis55722422arsis
arts49650262arts
as211083072a__s
ashes86230612ashes
asks85721212asks
aspis74618142aspis
asps65622092asps
ass37844062a_ss
ates45047922ates
auks85525262auks
auris55331522auris
aves76142602aves
avid88325962avid
aviso85713962aviso
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axil116424452axil
axils127217502axils
ayes76543512ayes
ayin76331742ayin
ayins85321612ayins
ays67050292a_ys
bahts105617802bahts
basis75429862basis
bis56860662_bis
bris65539612bris
cadis84428492cadis
chais107530312chais
chi86228652chi_
chia96026622chia
chias104625512chias
chic115925202chic
chics123920942chics
chid106626402chid
chin96934742chin
chins105631462chins
chip116726422chip
chips125721252chips
chit96937462chit
chits105424572chits
cis57748032_cis
cris66233432cris
dahls95012282dahls
dahs88231812dah_s
dais57040702dais
dashis104414392dashis
dis46459892_dis
egis56520652egis
gadis74825292gadis
ghi77019882ghi_
haes77651022haes
hags86740842hags
hahas117118442hahas
hahs108333362hahs
haik115526982haik
haiks125120932haiks
hail74839062hail
hails85231642hails
hair76330142hair
hairs86225172hairs
hajis156716272hajis
hams96446132hams
haps96443462haps
has67372652_has
hats76858252hats
haws106439442haws
hays106138072hays
hes66654202_hes
hi57947582_hi_
hic86540562_hic
hid76248362_hid
hie67652702_hie
hies74842832_hies
him86247652_him
hims95230972_hims
hin67559562_hin
hins76447992_hins
hip86750432_hip
hips96433702_hips
hisn79620932_hisn
hiss75629212_hiss
hist76551542_hist
hit66569192_hit
hits75545132_hits
hos68364192_hos
ibis66519582ibis
iris45732552iris
is27048212__is
iwis77117012iwis
kadis105921062kadis
kakis86116842kakis
khi106318302khi_
kis78051472_kis
kois85129392kois
kris86423602kris
lapis76223152lapis
laris54737462laris
lathis95516172lathis
leis45739602leis
lis37162272_lis
mavis105622722mavis
maxis145721562maxis
mhos95517772mhos
mis58162622_mis
nabis76020582nabis
naris55735292naris
nazis145216082nazis
oasis56422552oasis
obis66226842obis
ohia75719362ohia
ohias84415562ohias
ohms95514032ohms
ohs66232312oh_s
padis86227142padis
paris75145942paris
pavis106422732pavis
phi86524202phi_
phiz186718842phiz
pis56362032_pis
pois66539042pois
psis68120342psis
qadis155917852qadis
qis126934382_qis
rachis114017652rachis
ragis66325602ragis
rais45252622rais
rakis95323442rakis
ranis55235832ranis
raphis114014322raphis
reis45343232reis
rhos76319062rhos
rhus75114052rhus
sadis64930852sadis
sahib10314762sahib
sahibs1137082sahibs
sakis95323662sakis
saris54544952saris
satis55633672satis
seis45542392seis
shes75734352shes
shies86136552shies
shim95827842shim
shims104422542shims
shin75634302shin
shins85131042shins
ship95228232ship
ships105123772ships
shist84829602shist
shit76745932shit
shits84731162shits
shiv105721162shiv
shivs115018802shivs
shris84221442shris
sis37360542_sis
skis84825282skis
spahis11310382spahis
sris45434152sris
tahrs85412332tahrs
tamis76728722tamis
tapis75028862tapis
taxis126821972taxis
thin76732382thin
thins85826322thins
thio77225412thio
thir76420542thir
thus76721472thus
tis37056642_tis
tuis44829642tuis
vis66747612_vis
wadis95223962wadis
whid115418872whid
whids125413982whids
whig115516422whig
whigs125612642whigs
whim126220522whim
whims134515332whims
whin105225692whin
whins114922332whins
whip125521842whip
whips134917082whips
whir105519282whir
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whit
whits115923822whits
whiz195919942whiz
whys137011662whys
wis66552332_wis
xis106935332_xis
yagis95416572yagis
ywis105313102ywis

Search took 3 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 Filter178691298720.1401276364.3
2DLD Change Limit298723192.14313939.3
3Display Results3193190.1562044.9
 (SQL Overall)1786913192.43973264.0
 
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.