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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
substages1212735(None) 
substage11117181substage_
substates111410311substates
sabotages1244432sabotages
subsales10310122subs_ales
subscales1347342subscales
subspaces1545672subspaces
substances1446312substances
substate101711082substate_
substrates12168542substrates
upstages11147372_upstages
cabotages1444853cabotages
cubages1237923cub__ages
cuttages11297223cu_ttages
grubstakes1771743grubstakes
hostages122311693_hostages
offstages1652033offstages
outages82317323ou__tages
outstares91610183outstares
outstates91710753outstates
postages112815323_postages
restages92815763_restages
sabotage1144593sabotage_
sabotaged1342563sabotaged
sausages937003saus_ages
scutages1136503s_cutages
septages1168263s_eptages
shortages1336513shortages
soundstages1351513soundstages
stages75629493___stages
subbases1239063sub_bases
subframes1645853subframes
subgrades1346313subgrades
sublates10315003sub_lates
subleases1148653subleases
submerges1446283submerges
subphases1645753subphases
subraces12313033sub_races
subsale9310543subs_ale_
subscale1247603subscale_
subsenses1147473subsenses
subseres10312423subs_eres
subseries11312933subseries
subserves1447183subserves
subshafts1743093subshafts
subsides11410823subs_ides
subsidies1248403subsidies
subsites10312763subs_ites
subspace1445683subspace_
substance1346743substance
substrate11178783substrate_
subsumes1246923subs_umes
subtasks1444493sub_tasks
subtones10311373sub_tones
subtypes1544553sub_types
suffrages1644383suffrages
sullages939973su_llages
sunshades1344153sunshades
sunstones947873sunstones
surtaxes1536513su_rtaxes
sustains838553su_stains
unitages938273_unitages
unstates81314993_unstates
upstage10167443_upstage_
upstaged12135243_upstaged
upstager11164633_upstager
upstagers12173333_upstagers
upstares10178583_upstares
upstates10189643_upstates
usages759603_u_s_ages
wastages12109753_wastages

Search took 9 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641717.96618659.4
3Display Results71710.0332151.5
 (SQL Overall)178691718.15521911.8
 
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.