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

51 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
panfrying184299(None) 
pandying15217662pan_dying
parrying14168132pa_rrying
affraying1943103_affraying
annoying1246543_annoying
bandying15218073ban_dying
candying15188993can_dying
canopying1745063canopying
carrying14148373ca_rrying
dairying1336353da_irying
fancying1735353fan_cying
frying134511403___frying
harrying15157643ha_rrying
manuring1139223manur_ing
marrying14157233ma_rrying
nondrying1444683nondrying
nonflying1643673nonflying
pacifying2045503pacifying
pairing103716733pa_ir_ing
palsying1436233pa_lsying
pancaking1836383pancaking
pandering133211963pandering
paneling111013623pan_eling
panelling1239083panelling
panfried14134933panfr_ied
panfries13149203panfr_ies
panfry14456413panfry___
panging113319113pan__ging
panicking1835293panicking
panning104019393pan__ning
panting104025423pan__ting
papering132213313paper_ing
parging113318603pa__rging
paring94236493pa__r_ing
parking143423043pa__rking
parlaying1537303parlaying
parleying1536113parleying
parling103823763pa__rling
parodying1655423parodying
parring103222063pa__rring
parsing103819553pa__rsing
parting103527383pa__rting
partying14168893pa_rtying
paying123722163pa___ying
ponying133312123pon__ying
predrying1645343predrying
prying124114803p___rying
refrying15278903_refrying
salarying1336073salarying
tarrying12146723ta_rrying
varying1429723va__rying

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 Filter1786911486410.423422437.4
2DLD Change Limit148641516.43623095.2
3Display Results51510.0301700.0
 (SQL Overall)178691516.88925938.6
 
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.