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

59 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
eternity114668(None) 
eternise8119662eternise
eternize17118362eternize
maternity1444982maternity
paternity1444832paternity
sternite8310542sternite
acerbity1544273acerbity
alterity1149843alter_ity
amenity1238333ame_nity
celerity1347643celer_ity
dexterity2044343dexter_ity
eerily92913563e_er_ily
emerita938713emer_ita
emeriti949433emer_iti
enormity1344973enormity
equinity2045653equinity
esterify1445623ester_ify
eternal72910893etern_al
eternally1247493eternally
eternals8238953eternals
eterne6311723etern__e
eternised10116273eternised
eternises9119453eternises
eternities1048063eternities
eternized19116603eternized
eternizes18118013eternizes
etherify1744443ether_ify
extensity1944723extensity
externality2155043externality
extremity2153353extremity
ferity122813343_fer_ity
feterita1166463feter_ita
fraternity1652353fraternity
intercity14410003intercity
kernite1159473_kernite
legerity1245713leger_ity
lenity9612713_le_nity
modernity1543533modernity
quaternity2252743quaternity
serenity1168963_serenity
severity1446973sever_ity
sterility1247763sterility
sternites9310073sternites
sternly1037853stern_ly
sternway1443153sternway
temerity1346903temer_ity
tensity1039103_tensity
tenty86121603_te_n_ty
tenuity1037453_tenuity
tergite8311003_tergite
termite9313893_termite
ternary1038343_ternary
ternate7415483_ternate
ternion739493_ternion
terrify1336353_terrify
territ63421373_territ_
territs72714503_territs
trinity10310843_trinity
verity123714853_ver_ity

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.406440125.6
2DLD Change Limit146162597.18620339.8
3Display Results59590.0301966.7
 (SQL Overall)178691597.62223444.1
 
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.