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 “providing” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
providing163796(None) 
peroxiding2144932peroxiding
presiding13510902presiding
prevising15510872prevising
priding113317542pr__iding
prodding13189342pro_dding
profiling1548232profiling
profiting1549982profiting
promising14410972promising
propining14310132propining
provident1546222provident
proving134214072prov__ing
provoking1935132provoking
avoiding1336783avo_iding
braiding123112703br_aiding
brocading1556253brocading
broiling113112013bro_iling
bromizing2346583bromizing
brooding122911373bro_oding
crowding15247933cro_wding
dividing1437183_dividing
droving12379683drov__ing
drownding1564123drownding
eroding9314273ero__ding
erotizing1949963erotizing
griding103014973gr__iding
groining102310633gro_ining
grounding1236083grounding
groveling1435573groveling
improvising1943843improvising
ironizing1947933ironizing
jarovizing3043573jarovizing
loiding93313403_lo_iding
pervading1636303pervading
plodding13166343plo_dding
podding124113183p_o_dding
poinding122510003p_oinding
poising103617103p_o_ising
policing13311673p_olicing
pomading1437423p_omading
ponding114317083p_o_nding
positing11312303p_ositing
pounding123311473p_ounding
praising113214563pr_aising
prebidding1783843prebidding
prebinding1696163prebinding
preceding15129363preceding
precising14413273precising
precoding15109733precoding
prefading16149033prefading
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
preguiding1544493preguiding
prehiring1548383prehiring
preluding1337053preluding
premising14412413premising
premixing2157803premixing
prevailing1656723prevailing
previewing1943673previewing
prevuing1457253prev_uing
prewiring1547893prewiring
pricing123417343pr__icing
priming123417373pr__iming
prising103321453pr__ising
prizing193514683pr__izing
probating14311193probating
probing123314443pro__bing
proceeding1644673proceeding
procuring1437993procuring
producing1556143producing
profaning1537293profaning
profilings1653563profilings
progging132610383pro_gging
prologing1338953prologing
promoing13310463pro_moing
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
pronging123511843pro_nging
proofing1439313pro_ofing
propending1646143propending
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
prorating12314283prorating
prosing103319383pro__sing
protending1446813protending
protruding1453633protruding
proverbing1843783proverbing
provide1339853provid__e
provided1536843provid_ed
providence1854093providence
provider1436703provid_er
providers1535593providers
provides1439883provid_es
provision1447633provision
provisions1547213provisions
prowling1449993pro_wling
pyramiding1943533pyramiding
pyrolizing2546843pyrolizing
raiding93617593_r_aiding
ravining12269693_ravining
residing103015483_residing
reviling122917213_reviling
revising122714403_revising
reviving152910503_reviving
riding84325963_r__iding
rodding103814533_ro_dding
roiling83220453_ro_iling
rosining92411423_rosining
rounding102812283_rounding
roving103618743_rov__ing
voiding122910363_vo_iding

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.423422437.4
2DLD Change Limit1486411146.76321978.6
3Display Results1141140.0502280.0
 (SQL Overall)1786911147.23624694.7
 
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.