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

309 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
stat4735269(None) 
sat36288481s_at
scat65848371scat
seat47575561seat
shat76456601shat
skat87037901skat
slat46959021slat
spat66548521spat
stab67329931stab
stag57332001stag
star48037761star
start55642311start
state56237331state
stats55933361stats
staw78627691staw
stay78333721stay
stet45947321stet
stoat57135951stoat
stot46347331stot
swat77244441swat
tat37690291_tat
at212393402__at
atap66722452atap
att35454652at_t
bat510988952_bat
batt65053872batt
beat66168302beat
blat66550952blat
boat66360312boat
brat66055542brat
cat58282342_cat
chat95546132chat
coat67558352coat
doat56947672doat
drat56247832drat
eat36989052_eat
estate64719762estate
eta35834192eta_
etas46432272etas
fat68178082_fat
feat76458222feat
fiat76646642fiat
flat77147822flat
frat75648542frat
gat46880512_gat
ghat86435282ghat
gnat56034432gnat
goat56250832goat
grat55651282grat
hat67289962_hat
heat77061422heat
ikat87626642ikat
kat77468292_kat
khat116730722khat
kyat116025522kyat
lat37593402_lat
mat58083942_mat
matt65752662matt
meat66359602meat
moat66352032moat
neat46356782neat
oat39888262_oat
pat58089462_pat
peat65967932peat
phat95837862phat
plat66048872plat
prat65952042prat
qat125253332_qat
rat37892742_rat
sab56563202s_ab
sac57452862s_ac
sad47459202s_ad
sae38365182s_ae
sag46163402s_ag
sal36462882s_al
salt45758522salt
sap56463232s_ap
satay84718462satay
sate45556102sate
sati45539332sati
sau36356572s_au
saw68255352s_aw
sax107447642s_ax
say67264762s_ay
scab85926712scab
scad75725772scad
scag76626892scag
scam85932352scam
scan65530452scan
scant79735072scant
scar66434202scar
scart76139772scart
scats75930602scats
scatt76030092scatt
scot66242612scot
scut65835542scut
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seats54844342seats
sect67443622sect
sent46963012sent
sept65844362sept
set36681252s_et
seta45637312seta_
setae56026222setae
setal56430902setal
sett45949052sett
sext117338092sext
sha69837782sha_
shad86230912shad
shaft115725272shaft
shag86430562shag
shah105627782shah
shalt85534492shalt
sham96436362sham
shaw108132552shaw
shay107133342shay
shit76745942shit
shoat85633952shoat
shot76150262shot
shut76137592shut
sial45938832sial
sift710740662sift
silt46558192silt
sit35877752s_it
sitar54820542sitar
ska76925862ska_
skag96321512skag
skas85325712skas
skate94721552skate
skats94621542skats
skit85437532skit
slab67133762slab
slag55934352slag
slam67737972slam
slant55238702slant
slap66434042slap
slate55438282slate
slats55436902slats
slaty86523152slaty
slaw77930712slaw
slay76436382slay
slit46250102slit
slot46049832slot
slut45040592slut
smalt74729332smalt
smart75834092smart
smit65138412smit
smut66629782smut
snag55827872snag
snap65727032snap
snath86419802snath
snaw78923072snaw
snit46342472snit
snot44745452snot
soak87227662soak
soap65831132soap
soar46838672soar
soft76942822soft
soot45761062soot
sort46264812sort
sot310384302s_ot
spa55730812spa_
spae65034322spae
spait75631602spait
spam85930042spam
span65234662span
spar65433302spar
spas67036722spas
spate74731582spate
spats75031382spats
spay96631662spay
spaz155626162spaz
spit65545082spit
splat76129342splat
spot65540692spot
sprat76635972sprat
squat143720142squat
stabs76221382stabs
stack114421692stack
stacte82113912stacte
stade64825302stade
staff113817712staff
stage65330192stage
stags66226742stags
stagy96618892stagy
staid66722082staid
staig65519642staig
stain55727942stain
stair54719942stair
stake95927532stake
stale55637102stale
stalk94518002stalk
stall54722352stall
stamp95217362stamp
stand65923282stand
stane55933002stane
stang66424682stang
stank95823302stank
staph104314652staph
stare54440262stare
stark95425622stark
stars55836572stars
starts65423122starts
stash84916972stash
statal61613222statal
stated75427832stated
stater64427562stater
states64337082states
static83118682static
statin63921472statin
stator64015482stator
statue66015322statue
status65515212status
stave85324992stave
stays86022022stays
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
stem610628252stem
stent55634512stent
step67126292step
stets55423912stets
stew77525462stew
stey76224412stey
stilt54831982stilt
stint57037662stint
stir45723252stir
stoa45425912stoa
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoats65117482stoats
stob66724612stob
stop66532032stop
stopt76528352stopt
stots54828552stots
stott56929792stott
stout57434052stout
stow77325742stow
strait64025892strait
strap77925262strap
strata63616282strata
strath93216372strath
strati63518902strati
straw813321292straw
stray88525572stray
strut56030732strut
stub66221842stub
stud56220092stud
stum65526022stum
stun45623452stun
stunt55328172stunt
sturt56028962sturt
sty66227312st_y
stye76218972stye
suet46754822suet
suit45649872suit
sutta54015332sutta
swab96825312swab
swag87526732swag
swam96329982swam
swan76631312swan
swap95925432swap
swart86234642swart
swath115920382swath
swats85726862swats
sway107128232sway
sweat85628402sweat
swot75134662swot
ta211662452_ta_
tab57460322_tab
tact67349032_tact
tad47959822_tad
tae38267052_tae
tag47259492_tag
taj106442192_taj
tam58663422_tam
tan37167572_tan
tao38358952_tao
tap57663872_tap
tar37570692_tar
tart47566182_tart
tas38477102_tas
tate44748602_tate
tats46858132_tats
tau36856902_tau
taut47048962_taut
tav66043212_tav
taw610155452_taw
tax109449152_tax
teat45963632teat
tet39274992_tet
that75639322that
tit36771052_tit
tot38884772_tot
tsar47819802tsar
tut36758092_tut
twat75831512twat
uta37425582uta_
utas45924952utas
vat67863452_vat
wat67378922_wat
watt75545412watt
what105434072what

Search took 2 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.280638182.1
2DLD Change Limit298723090.84335435.3
3Display Results3093090.0803862.5
 (SQL Overall)1786913091.203148537.8
 
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.