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

214 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
stage6533019(None) 
sage55044591s_age
stade64825301stade
stag57332001stag_
staged84521561staged
stager74821341stager
stages75629491stages
stagey105915581stagey
stags66226741stags
stagy96618891stagy
stake95927531stake
stale55637101stale
stane55933001stane
stare54440261stare
state56237331state
stave85324991stave
swage94919561swage
adage7414052adage
age47154332__age
cage75339062_cage
dotage82711612dotage
estate64719762estate
etape74413702etape
gage65936102_gage
hostage113111232hostage
image81411292image
mage75739132_mage
metage93114452metage
onstage838362onstage
outage72017532outage
page76036102_page
peage84723572peage
phage115113672phage
plage84520402plage
postage103214852postage
potage92715902potage
rage55742352_rage
restage83316192restage
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sag46163402s_ag_
saga55331172s_aga
sager65432052s_ager
sages65339062s_ages
sago56332672s_ago
sags55948402s_ags
sagy85327082s_agy
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sarge65531132sarge
sate45556102s_ate
savage10410172savage
save75741362s_ave
scag76626892scag_
scags85520972scags
scale74629142scale
scape96921842scape
scare75334462scare
scutage1036332scutage
sedge75019972sedge
septage1078402septage
serge64727472serge
setae56026222seta_e
sewage10310732sewage
shade95125582shade
shag86430562shag_
shags95123862shags
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
siege66718442siege
silage72715302silage
singe65731132singe
skag96321512skag_
skags104316072skags
skate94721552skate
slag55934352slag_
slags66525902slags
slake93724052slake
slate55438282slate
slave84224032slave
smaze165012932smaze
snag55827872snag_
snags64421312snags
snake94821112snake
snare54429982snare
soave84219052soave
socage91012122socage
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spare75135562spare
sparge94216052sparge
spate74731582spate
stab67329932sta_b
stable83921642stable
stabs76221382stabs
stack114421692stack
stacte82113912stacte
stades74626242stades
staff113817712staff
stagers84116672stagers
stagged104212082stagged
stagger94212392stagger
staggie9138462staggie
staggy115510392staggy
stagier83513442stagier
staid66722082staid
staig65519642staig
staigs75414812staigs
stain55727942stain
stair54719942stair
staked114621942staked
stakes103927292stakes
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stamen84115942stamen
stamp95217362stamp
stance84316912stance
stand65923282stand
staned74824642staned
stanes64933402stanes
stang66424682stang
stanged94113842stanged
stangs75018162stangs
stank95823302stank
stapes85028732stapes
staph104314652staph
staple84415822staple
star48037762sta_r
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
stases64225562stases
stash84916972stash
stat47352692sta_t
stated75427832stated
stater64427562stater
states64337082states
stats55933362stats
statue66015322statue
staved103918052staved
staves94525192staves
staw78627692sta_w
stay78333722sta_y
stayed104817272stayed
stayer94516482stayer
stays86022022stays
stele55026842stele
stere55328542stere
stile54931572stile
stime76521802stime
stipe76523372stipe
stoae55024262stoae
stodge8369042stodge
stogey105811542stogey
stogie7311322stogie
stogy95414082stogy
stoke94922512stoke
stole54928812stole
stone55431182stone
stooge73811662stooge
stope74727242stope
storage8310472storage
store56333812store
stove85220252stove
stowage1136702stowage
strafe95215982strafe
strake104017392strake
strange85416342strange
stupe75217752stupe
stye76218972st_ye
style85519362style
suave83519872suave
surge65027692surge
swag87526732swag_
swaged114212252swaged
swager104013612swager
swages104417072swages
swags94921252swags
swale85221592swale
sware85828212sware
tace65342512_tace
tae38267052_ta_e
tag47259492_tag_
tags55545232_tags
take84739262_take
tale46154162_tale
tame66343662_tame
tape64538142_tape
tare45957622_tare
targe65227092_targe
tate44748602_tate
tsade64311122tsade
upstage10167442upstage
usage6410212usage
wage84834082_wage
wastage11109252wastage

Search took 4 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 Filter178691538000.623286823.4
2DLD Change Limit538002142.61020613.0
3Display Results2142140.0464652.2
 (SQL Overall)1786912143.27954495.6
 
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.