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

57 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
portending144619(None) 
protending1446811protending
bartending1444912bartending
contending1449122contending
forfending1844182forfending
perpending1646682perpending
portering122012302porte_ring
pretending1438612pretending
propending1646142propending
attending11136373_attending
coattending1543543coattending
coextending2252913coextending
commending1846633commending
contenting13313323contenting
distending1348333distending
extending1835853_extending
forefending1943493forefending
fortuning1345493fortun_ing
friending1495553_friending
goaltending1451993goaltending
intending1139983_intending
mistending1447953mistending
nonending1138003no_nending
obtunding1354243_obtunding
offending1744093_offending
orienting1038723_orienting
parenting12611583par_enting
partnering1345553partnering
patenting1248943p_atenting
pending114119773p___ending
poinding122510003po__inding
pollening1236923pollen_ing
ponding114317083po___nding
portaging1346843port_aging
portend103411193portend___
portended1345643portend_ed
portends11358963portend__s
porting103021783port___ing
portioning1347193portioning
portraying1645163portraying
postlanding1543833postlanding
pottering122612003potte_ring
pounding123311473po__unding
preening113115843p_reen_ing
proceeding1644673proceeding
promenading1774373promenading
protecting151910213protecting
protesting131910253protesting
protruding1453633protruding
rending93924263__r_ending
shortening1445303shorten_ing
softening1365493soften_ing
subtending1445103subtending
tending94419163___tending
tormenting1345693tormenting
trending103012833_tr_ending
worsening1345553worsen_ing

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.500357382.0
2DLD Change Limit140603576.04623255.5
3Display Results57570.0301900.0
 (SQL Overall)178691576.57627173.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.