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

79 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
stupefy154290(None) 
stuffy15317082stu_ffy
stupe75217752stupe__
stupes84116952stupe_s
tepefy1434802_tepefy
tumefy1434222_tumefy
astutely1153643astutely
dupery12378743_dupery
putrefy1543313putrefy
scurfy14338763scu_rfy
shapely1536893shapely
snuffy15356243snu_ffy
souped95017673soupe_d
soupy106115403soup__y
squiffy2542573squiffy
stagey105915583stage_y
stalely1039213stalely
stapes85028733stape_s
stately10310223stately
steely93612573st_eely
steeply1236293steeply
stewy116112063st__ewy
stey76224413st__e_y
stipe76523373stipe__
stiped94517073stipe_d
stipel84412123stipe_l
stipels9418953stipels
stipend10386553stipend
stipes84524053stipe_s
stogey105811543stoge_y
stonefly1443473stonefly
stoney96217353stone_y
stope74727243stope__
stoped94721013stope_d
stoper84320103stope_r
stopers94217373stopers
stopes84525893stope_s
stopoff1565023stopoff
storey95217613store_y
stubbly1444473stubbly
stubby1345043stu_bby
student848343student
studly10397693stu_dly
study94411793stu__dy
stuff113817053stu__ff
stuffed14328973stuffed
stuffer13349793stuffer
stuffs123810223stu_ffs
stultify1442723stultify
stumped124210153stumpe_d
stumper113610093stumpe_r
stumpers12318313stumpers
stumpy13458133stu_mpy
stupa74112313stup__a
stupas83910883stup_as
stupefied1542673stupefied
stupefier1442653stupefier
stupefies1443833stupefies
stupefying1942013stupefying
stupid937593stup_id
stupidly1442633stupidly
stupids1035273stupids
stupor836013stup_or
stupors935883stupors
sturdy1037043stu_rdy
suety85318493s_u_ety
supe65932763s_upe__
super74924483s_upe_r
superb104410993s_uperb
supers84622403s_upers
supes75628303s_upe_s
supply1346893s_upply
surely93816463s_urely
surety93515013s_urety
surfy115319473s_u_rfy
tupelo836483_tupelo
turfy114315403_tu_rfy
typey135511883_type_y
typify1734523_typify

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 Filter1786911340270.406440125.6
2DLD Change Limit134027796.44020811.6
3Display Results79790.0302633.3
 (SQL Overall)178691796.87625987.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.