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

77 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
putrefy154331(None) 
petrify1536572petrify
purely114013632pu_rely
purify14399152pu_rify
butlery12369423butlery
buttery124311193buttery
curtesy1265833curtesy
cutely115312803cut_ely
cutesy114810733cut_esy
cutey105819793cut_e_y
cutlery12448393cutlery
guttery11427763guttery
introfy1344753introfy
metrify1535623metrify
murrey114312263murre_y
mutely113811653mut_ely
nitrify1335793nitrify
outre53922203outre__
outread82811093outread
petrel83111533petre_l
petrels9279373petrels
phoresy1534653phoresy
pottery123011073pottery
prexy174611583p__rexy
prey96228483p__re_y
puberty1444783puberty
puckery18306263puckery
puffery18235113puffery
puffy164410753pu__ffy
pugree92112473pugre_e
pugrees10218523pugrees
pulley113713403pulle_y
punkey154011173punke_y
pure65543333pu_re__
puree74632843pu_re_e
pureed95017813pu_reed
purees84721683pu_rees
purer75127903pu_re_r
purest84021933pu_rest
purity114114913pu_rity
purply13369053pu_rply
purred94218073purre_d
pursy105016413pu_r_sy
purty105019403pu_r_ty
purvey14559573pu_rvey
pusley11379613pusle_y
putoff1436423put_off
putoffs1543333putoffs
putrefied1543673putrefied
putrefier1443123putrefier
putrefies1444663putrefies
putrefying1942953putrefying
putrid9311173putr_id
putridly1443493putridly
putted94220253putte_d
puttee85919723putte_e
puttees93612913puttees
putter83921443putte_r
putters94219193putters
putty104721403put__ty
putzed18409113putze_d
putzes174212523putze_s
rarefy12296343_rarefy
spurrey12307813spurre_y
sputtery13366473sputtery
stupefy1542903stupefy
surely93816463su_rely
surety93515013su_rety
surfy115319473su_r_fy
surrey94414583surre_y
torrefy1353353torrefy
tref77030993__tref_
trey77228793__tre_y
tumefy1434223tu_mefy
turfy114315403tu_r_fy
uptrend1044293uptrend
vitrify1645003vitrify

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 Filter1786911340270.406440125.6
2DLD Change Limit134027777.15318737.2
3Display Results77770.0332333.3
 (SQL Overall)178691777.59223536.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.