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

89 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
ablegate114726(None) 
ablegates1246811ablegates
abnegate1144871abnegate
ablate82219212abl__ate
abnegated1344172abnegated
abnegates1244962abnegates
abrogate11129612abrogate
delegate10410462delegate
legate72917452__legate
obligate11198302obligate
relegate9311242relegate
tablemate1344832tablemate
abate76627843ab___ate
abdicate1348903abdicate
ablated102513443abl__ated
ablates92416913abl__ates
ablaze17239833abl__aze
ableist9311783ableist_
ableists1036563ableists
ablest84721833able_st_
abnegator1243613abnegator
abrogated13126723abrogated
abrogates12108993abrogates
acerate92818913a_cerate
acetate92514753a_cetate
acierate10311813acierate
aculeate1039923acule_ate
aerate64830553a__erate
agate66525153a___gate
agemate101210583a_gemate
aggregate1244213aggregate
alate55340333a_l__ate
alegar739283a_lega_r
alegars838933a_legars
algae65319623a_l_ga_e
alienate8311553alienate
allege74314653alleg__e
alleviate1246083alleviate
allocate10411023allocate
ameerate1039633ameerate
antedate949693antedate
arrogate91210323arrogate
arsenate81010483arsenate
asperate10312373asperate
aureate72515293aure_ate
baldpate1345483baldpate
ballgame1343653ballgame
begat86629723_b_egat_
begaze1838333_b_egaze
berate84729023_b_erate
blate75933783_bl__ate
bleat75737003_ble_at_
bleated104015973_ble_ated
bleater94515303_ble_ater
bleats85518623_ble_ats
bregmate1345543_bregmate
delegated1238373delegated
delegatee1148813delegatee
delegates1139843delegates
elevate101110373_elevate
galeate83916793gale_ate
labellate11126933labellate
legated92513983__legated
legatee82814633__legatee
legates82917683__legates
legato72810953__legato
ligate72519253__ligate
maleate94117543male_ate
negate72915573__negate
oblate82214743obl__ate
obligated13186903obligated
obligates12207853obligates
obligati11184833obligati
obligato11194983obligato
oleate6318883_ole_ate
paleate94120003pale_ate
pileate93815923pile_ate
relegated1139763relegated
relegates10310943relegates
selenate81712533selenate
stablemate1452723stablemate
tablemates1444703tablemates
tableware1443183tableware
tailgate946823tail_gate
tolerate8312323tolerate
tollgate946253tollgate
valerate11311473valerate
variegate1344103variegate
vulgate11388433vul_gate

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 Filter1786911461620.423422437.4
2DLD Change Limit146162897.62319173.8
3Display Results89890.0302966.7
 (SQL Overall)178691898.07622126.2
 
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.