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

140 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
petrify153657(None) 
metrify1535621metrify
aerify122810112ae_rify
certify1546242certify
gentrify1544682gentrify
nitrify1335792nitrify
pettily1238172pettily
prettify1644342prettify
purify14399152p_urify
putrefy1543312putrefy
terrify1336352terrify
verify153110162ve_rify
vitrify1645002vitrify
acetify1545003acet_ify
aerily93017013ae_rily
beatify1536593beatify
betray111511443betr_ay
citify1437443cit_ify
clarify1536093clarify
deify124112763de__ify
denitrify1643073denitrify
densify1435293densify
detoxify2262173detoxify
devitrify1941963devitrify
edify12308563_e_dify
eerily92913563_eerily
electrify1744673electrify
esterify1445623esterify
etherify1744443_etherify
ferity122813343fe_rity
fortify1636523fortify
glorify1444583glorify
horrify1635023horrify
introfy1344753introfy
jellify2054543jellify
leerily1037633leerily
lithify1644763lithify
merrily1238633merrily
metric10314683metri_c
metrics11312363metrics
metring103215293metring
metrist9317063metrist
micrify1744693micrify
mortify1536223mortify
nigrify1444133nigrify
notify1236943not_ify
pacify1667473p_acify
paltrily1345413paltrily
parity114719873p_arity
patriot9314533patriot
pearly116414843pear_ly
peartly1267453peartly
peerie83617893peeri_e
peeries93623023peeries
peering103520353peering
peery105719443peer__y
peltries10313023peltries
peltry11288653peltr__y
peppily1335133peppily
perdy115417333pe_r_dy
perfidy1635273perfidy
peri65636973pe_ri__
peril75425953pe_ri_l
perils84121853pe_rils
period9314983pe_riod
peris75537073pe_ri_s
perish114619063pe_rish
periti8319953pe_riti
perkily1637813perkily
perky145319483pe_r_ky
peroxy1838253pe_roxy
perries93226603perries
perry105222713pe_r_ry
pertly115312553pe_rtly
peskily1635083peskily
petering112516813petering
petit74332653pet_i_t
petite84320653pet_ite
petrale9312623petrale
petrel83111533petr_el
petrels9279373petrels
petrified1548333petrified
petrifier1447123petrifier
petrifies14310363petrifies
petrifying1945823petrifying
petrol82714063petr_ol
petrols92913083petrols
petrous92714423petrous
petti75119453petti__
pettier94213613pettier
pettifog1442053pettifog
petting103720953petting
pettish1238283pettish
petty105320293pet__ty
pithily1567033pithily
pleurisy1343663pleurisy
poetries10315583poetries
poetry1139383poetr__y
pretrial10511983pretrial
pretrim11310783pretri_m
pretrims1238983pretrims
prettily1337283prettily
pricy124814563p__ricy
privy13439833p__rivy
pterin81014153pteri_n
pterins9812993pterins
purity114114913p_urity
putrid9311173putri_d
putridly1443493putridly
rarify123210063_rarify
ratify122610043rat_ify
rectify1536453rectify
reedify1465763reedify
reify114814973re__ify
repurify1643803repurify
retrial7615553retrial
retried84419153retried
retries74129073retries
retrim83514883retri_m
retrims93612373retrims
retry84718083retr__y
reunify1344453reunify
reverify1744813reverify
scarify1537443scarify
scorify1535203scorify
serif84132133se_rif_
serifs94017053se_rifs
specify1764993spe_cify
strife95318363_strife
stripy115812743_stripy
tearily10311153tearily
testify13246943testify
tetri52716453tetri__
tetris62816293tetri_s
torrify1335013torrify
verbify1834993verbify
verily122616053ve_rily
verity123714853ve_rity
versify1636333versify
wearily1338783wearily

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 Limit1340271406.43620824.6
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.88825942.4
 
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.