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

52 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
neglecting144454(None) 
deflecting1736502deflecting
electing112113782_e_lecting
reelecting1338782reelecting
reflecting1638822reflecting
selecting12310532se_lecting
beflecking2243033beflecking
begetting13186583beg_etting
collecting1548283collecting
defecting162510223de_fecting
dejecting20217793de_jecting
deleting103314423de_le_ting
depleting1378193deple_ting
deselecting1544473deselecting
detecting13259983de_tecting
effecting1845583_effecting
egesting1039013_eg_esting
ejecting18268163_e_jecting
englutting1242723englutting
erecting112415063_e_recting
expecting2146693_expecting
exsecting1935933_exsecting
gleeting10279173__gleeting
inflecting1646313inflecting
negating102012833neg__ating
neglect1047363neglect___
neglected1354693neglect_ed
neglecter1263633neglect_er
neglecters1362933neglecters
neglectful1651473neglectful
neglector1253433neglect_or
neglectors1363543neglectors
neglects1144383neglect__s
nucleating1346943nucleating
pelleting1237953pelle_ting
perfecting1847513perfecting
preelecting1646473preelecting
prelecting15310163prelecting
reejecting2045813reejecting
reerecting1339973reerecting
refecting152413353re_fecting
regelating1239953regelating
regreeting1237343regreeting
regretting1237783regretting
rejecting192211153re_jecting
relenting102716773re_lenting
reletting102713943re_letting
relucting1239773re_lucting
resecting122816483re_secting
reselecting1446023reselecting
respecting1549883respecting
segmenting1445003segmenting

Search took 7 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 Filter1786911406030.453394461.4
2DLD Change Limit140603526.20322666.9
3Display Results52520.0163250.0
 (SQL Overall)178691526.67226782.2
 
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.