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

36 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
dognapers134307(None) 
dognaper1243691dognaper_
dognappers1642051dognappers
dognaped1343492dognape_d
dognapper1542432dognapper_
dognaps1134392dognap__s
catnapers1364763catnapers
cognates11311583cognate_s
cognizers2164433cognizers
degraders12245933degraders
diapers104713913d__iapers
dogbanes1245433dogbane_s
dogears937513dogea__rs
dogfaces1554143dogface_s
doggers104413433dog__gers
dognap1035343dognap___
dognaping1443183dognaping
dognapped1642143dognapped
dogvanes1344303dogvane_s
donates83217223do_nate_s
donators9310403do_nators
donnikers1443443donnikers
dopers95522483do___pers
dorpers104113173do__rpers
douzepers2142043douzepers
dowagers1334893do_wagers
downers113912773down__ers
drapers105313353d__rapers
gapers94520473__g_apers
gnawers11356393__gnawers
hanapers1346963_hanapers
kidnapers1652473kidnapers
onagers838103_o_nagers
petnapers1343823petnapers
signalers1044583signalers
soapers93715923so__apers

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 Limit148641366.98621277.0
3Display Results36360.000 
 (SQL Overall)178691367.40624127.9
 
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.