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

284 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
ask7713070(None) 
ark77044961ark
as211083071as_
ash67944601ash
asks85721211asks
asp57235341asp
ass37844061ass
auk76234141auk
bask105131421bask
cask105626431cask
mask105227361mask
task85326651task
tsk75814731tsk
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abo59045962abo
abs59356072abs
aby810238062aby
ace59656832ace
act59557842act
ad311975042a_d
add510132372add
ado49146882ado
ads49755742ads
adz1312332872adz
ae212590292a_e
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
ago48845522ago
ags47551662ags
ah513868792a_h
aha611246642aha
ahi68040232ahi
ahs68644822ahs
ai211288402a_i
aid49269092aid
ail37171052ail
aim57858222aim
ain37579102ain
air38058402air
ais39083582ais
ait38093912ait
al210674042a_l
ala312463602ala
alb57342652alb
ale36572342ale
alky115920342alky
all36148232all
alp56641132alp
als36663022als
also46423442also
alt36467962alt
am411875562a_m
ama510853312ama
ami56646812ami
amok10217402amok
amp77541022amp
amu58237322amu
an211879082a_n
ana39559832ana
and47244182and
ane37866952ane
ani37751182ani
ankh111114412ankh
ansa45927772ansa
ant37270792ant
any68440492any
ape57251182ape
apo511142122apo
app76827602app
apse67725382apse
apt57352542apt
ar211379382a_r
arak86929582arak
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
arks85936872arks
arm58449632arm
ars37670932ars
arse46539272arse
art38679142art
asci66519142asci
asea46327182asea
ashy107717352ashy
asked106919312asked
asker96418782asker
askew12529412askew
askoi9507802askoi
askos95011772askos
asps65622092asps
at212393402a_t
ate37059242ate
att35454652att
auks85525262auks
ava610139322ava
ave67748702ave
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
ay511773892a_y
aye67151762aye
ays67050292ays
azo128233392azo
back125535762back
balk105132222balk
bank105835752bank
bark106242152bark
bas58681752bas_
base64847022base
bash915240162bash
basks115621762basks
bass66146782bass
bast66362412bast
bisk106523362bisk
bosk105825732bosk
busk105429222busk
calk105527662calk
cark105539272cark
casa65630862casa
case65848082case
cash96636282cash
casks115720062casks
casky144512682casky
cast67159902cast
cusk105521632cusk
dak86340692dak
daks97130602daks
dank95828242dank
dark95133212dark
dash87031632dash
dawk126117282dawk
desk95618902desk
disk96625842disk
dusk95724152dusk
ease45042332ease
east46659102east
easy76224492easy
eek77935102eek
elk76726122elk
es29048222es_
ess36030882ess
fas68262932fas_
fash107232292fash
fast77052312fast
flask125512422flask
gas48870252gas_
gash86833022gash
gasp76227332gasp
gast56052562gast
gawk126716692gawk
hack135134542hack
haik115526982haik
hank115134142hank
hark115237392hark
has67372652has_
hash106936502hash
hasp96627292hasp
hast76259482hast
hawk145521152hawk
husk116021952husk
ick97329332ick
ilk78325312ilk
ink76433642ink
irk76426372irk
is27048222is_
ism56322392ism
jack175224862jack
jauk155816092jauk
kas77058592kas_
lack105837682lack
lank84734452lank
lark85733862lark
las37281472las_
lase46148512lase
lash76539652lash
lass47444542lass
last46260322last
lek75640302lek
mack125733652mack
mark105138062mark
mas58175822mas_
masa65034722masa
mash96039402mash
masks115320532masks
mass66044942mass
mast65959962mast
mosk105622442mosk
musk104526192musk
nark85230062nark
oak76238652oak
oaks86527902oaks
oast47156322oast
os211359882os_
ose38147342ose
pack125535442pack
paik105726802paik
park105237492park
pas58775742pas_
pase65346862pase
pash95638132pash
pass65239952pass
past65959012past
psi56621622psi
pst57932512pst
rack106234882rack
rank85135532rank
ras37575392ras_
rase46149982rase
rash76039932rash
rasp66029162rasp
risk85724112risk
rusk85823312rusk
sab56563202sab
sac57452862sac
sack105337312sack
sad47459212sad
sae38365182sae
sag46163402sag
sake85244962sake
saki85628482saki
sal36462882sal
sank85236832sank
sap56463232sap
sark84938972sark
sash77235302sash
sass45035622sass
sat36288482sat
sau36356572sau
saw68255352saw
sax107447642sax
say67264762say
sh56828522_sh
si29149582_si
ska76925862_ska
ski74925702_ski
sky106420992_sky
so28855442_so
suk75632972suk
tack106536292tack
talk86230092talk
tank85134032tank
tas38477102tas_
tasks94917582tasks
tass45640572tass
tsks86410662tsks
tusk85621632tusk
us26937432us_
use36835162use
vas67755772vas_
vasa76522972vasa
vase75629652vase
vast75045122vast
wack135330912wack
walk115625612walk
wank115632512wank
wark115737772wark
was68767562was_
wash106033812wash
wasp95626852wasp
wast75655852wast
wauk115220592wauk
wok106334172wok
yack135425972yack
yak107038562yak
yaks116025202yaks
yank115423672yank
yok107335242yok
yuk106725602yuk
zas126946832zas_
zek167323162zek

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.250714764.0
2DLD Change Limit140842840.40634689.7
3Display Results2842840.0466173.9
 (SQL Overall)1786912840.702254545.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.