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

58 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
elongate94561(None) 
elongated1144281elongated
elongates1045381elongates
bloviate1384913bloviate
clodpate1344083clodpate
cognate10312203_cognate
connate9315753_connate
delegate10410463del_egate
delineate1047793delineate
derogate10311353dero_gate
detonate9311193deton_ate
donate73619503_don_ate
ebonite9310293ebon_ite
eclogite1146303eclo_gite
edentate947703edentate
elate55335883el___ate
elevate101110373el_evate
elongating1244523elongating
elongation1145353elongation
eluate62315433el__uate
eluviate1146953eluviate
emanate9312473eman_ate
emendate1146783emendate
enate54428153e__n_ate
engage82812103e__ngage
ergate7315143e__rgate
exonerate16107733exonerate
floodgate1472523floodgate
fluxgate1942893fluxgate
globate1057823glo_bate
ingate73018243__ingate
lanate6421263_lan_ate
legate72917453_l_egate
levigate1246623levigate
ligate72519253_l_igate
lineate7815153_lineate
lobate82915243_lo_bate
locate83919843_lo_cate
loggats9286453_loggats
longan75612363_longa_n
longans84510813_longans
longe66626463_long__e
lunate6316043_lun_ate
melongene1243633melongene
neonate7311333neon_ate
nongame1038183_nongame
odonate848403odon_ate
ozonate1646863ozon_ate
phonate12411813phon_ate
planate9314573plan_ate
pronate9418873pron_ate
relegate9311243rel_egate
relocate10713533relo_cate
resonate8513513reson_ate
selenate81712533selen_ate
togate74515683_to_gate
tollgate946253tollgate
zonate154114923_zon_ate

Search took 8 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.436409841.7
2DLD Change Limit146162587.43619656.0
3Display Results58580.0331757.6
 (SQL Overall)178691587.90522604.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.