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 “achieving” 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
achieving184330(None) 
archiving1844762archi_ving
scrieving1534132scrieving
thieving1535142_thieving
acceding1446093ac_ceding
accreting1446333accreting
achieve1545023achiev__e
achieved1743713achiev_ed
achiever1643843achiev_er
achievers1743433achievers
achieves1645523achiev_es
aching126521973ach___ing
adhering1338883adh_ering
aggrieving1681483aggrieving
aliening91510893a_liening
arriving1237363arri_ving
ashlering1344153ashlering
atheling1249203ath_eling
believing1535283believing
cacheting1737153cach_eting
cashiering1643783cashiering
cheeking18349083_cheeking
cheeping16329553_cheeping
cheering143612703_cheering
cheesing14349413_cheesing
chefing16359033_ch_efing
chevying2034053_ch_evying
chewing163911143_ch_ewing
chiding143911593_chi_ding
childing15288503_childing
chilling143512183_chilling
chiming153311833_chi_ming
chining133316843_chi_ning
chinking183210893_chinking
chinning14329653_chinning
chipping18389793_chipping
chirking18339383_chirking
chirming16318643_chirming
chirping16278863_chirping
chirring142610173_chirring
chiseling1536403_chiseling
chitling142910663_chitling
chivvying2441713_chivvying
chivying2034973_chivying
grieving1385893_grieving
hieing104216623__hie_ing
hiving134115523__hi_ving
machining1746933machi_ning
ochering14219393och_ering
outachieving2151153outachieving
racheting1537793rach_eting
relieving1336693relieving
scheming1636633sch_eming
schilling15286393schilling
scriving14258763scri_ving
shieling123512403_shieling
shrieving1633973shrieving
sieving112311233__sieving

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 Filter1786911486410.420425454.8
2DLD Change Limit148641587.12620859.0
3Display Results58580.0301933.3
 (SQL Overall)178691587.57623586.5
 
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.