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

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

162 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
onstage83836(None) 
downstage1443372downstage
hostage113111232hostage
instate71616482instate
montage101211712mon_tage
offstage1541902offstage
outage72017532o_utage
postage103214852postage
restage83316192restage
stage65330192__stage
unitage838992unitage
unstate71916212unstate
upstage10167442upstage
wastage11109252wastage
anatase738943anatase
anlage72514233an_lage
ansae55720973ans_a_e
ansate64517863ans_ate
antae56828293an_ta_e
assuage835683assuage
asswage1144673asswage
bistate9313823bistate
bondage1138253bon_dage
boscage1276533boscage
boskage1465413boskage
cartage10312593cartage
constable13311003constable
constant10515593constant
construe1049053construe
corsage1039803cors_age
costae85319683costa_e
costate94019273costate
cottage104210573cottage
cuttage10318343cuttage
dosage82810003dos_age
dotage82711613_dotage
downstages1543293downstages
downstate1344613downstate
ecotage1036883ecotage
encage93713503en_cage
engage82812103en_gage
enrage72715073en_rage
ensilage944713ensilage
enslave1036273enslave
ensnare767123ensnare
estate64719763_estate
flotage1136683flotage
footage1148843footage
forestage1346973forestage
frontage1296243fron_tage
gestate83614073gestate
hastate10313913hastate
hostages122311693hostages
incage93513623in_cage
innage73011573in_nage
insane6314893ins_ane
inscape1138023inscape
insnare748243insnare
instable10313203instable
instal6712193insta_l
install779363install
instals7611713instals
instance1049883instance
instant7815353instant
instar6310013insta_r
instars7411133instars
instated91613343instated
instates81615833instates
intake10510863in_take
massage1039893massage
meltage1037953meltage
message1037833message
metage93114453_metage
mintage101110123mintage
mispage12310523mispage
mistake131312623mistake
montaged12107763mon_taged
montages111412183mon_tages
montane91313623mon_tane
nonage7313683_nonage
nonimage1144883nonimage
nonstaple1144923nonstaple
nonstyle1145003nonstyle
nonwage1137163nonwage
notate63217863_notate
nutate63017373_nutate
obstacle1243593obstacle
octane81411633o_ctane
octave11157343o_ctave
offstages1652033offstages
ohmage1295063o_hmage
onager739663on__ager
onetime937623onetime
onshore10310013onshore
onside7511803ons_ide
outages82317323o_utages
outate62923403o_utate
outrage82616893outrage
outstare81410693outstare
outstate81411993outstate
outtake11310793outtake
overage11514053overage
passage1039803passage
portage103013643portage
postages112815323postages
potage92715903_potage
pottage103310603pottage
restaged103011863restaged
restages92815773restages
restate73824883restate
rootage839053rootage
sage55044593__s_age
scutage1036333scutage
septage1078403septage
soundstage1251323soundstage
stade64825303__stade
stag57332003__stag_
staged84521563__staged
stager74821343__stager
stages75629493__stages
stagey105915583__stagey
stags66226743__stags
stagy96618893__stagy
stake95927533__stake
stale55637103__stale
stane55933003__stane
stare54440263__stare
state56237333__state
stave85324993__stave
substage11117183substage
swage94919563__swage
tentage81010643tentage
testae64216253testa_e
testate73916233testate
tonnage8168053ton_nage
uncage93014873un_cage
unitages938273unitages
unsafe9310693uns_afe
unsnag736393unsnag_
unsnags835463unsnags
unstable10313763unstable
unstack1337373unstack
unstated91615813unstated
unstates81314993unstates
unstayed12168393unstayed
untame82513603un_tame
upstaged12135243upstaged
upstager11164633upstager
upstages11147373upstages
upstare9158683upstare
upstate91610493upstate
usage6410213_us_age
vantage11109893vantage
ventage11109623ventage
vestige1137433vestige
vintage11128143vintage
visage1049083vis_age
voltage1136863voltage
waftage14115323waftage
wantage11119623wantage
wastages12109753wastages
wattage1186983wattage

Search took 7 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 Filter1786911340270.440406115.9
2DLD Change Limit1340271626.23321502.8
3Display Results1621620.0463521.7
 (SQL Overall)1786911626.71926594.9
 
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.