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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
personified176391(None) 
personifier16133451personifier
personifies1695151personifies
personifiers1771952personifiers
opsonified1652153_opsonified
personalised1554443personalised
personalized2455873personalized
personated13258293person_ated
personify1744013personif__y
personifying2152373personifying
premodified20113583premodified
prenotified1753983prenotified
presignified1952443presignified
resinified1445763re_sinified
versified16147593vers__ified
aerified121310134aer___ified
ammonified1892994_ammonified
carnified1547294car__nified
certified1548414cer__tified
cornified1546624cor__nified
densified1446714dens__ified
detoxified2243084de_toxified
opsonifies1542454_opsonifies
peptonized2455574peptoni_zed
peroxided2045074per_oxi_ded
persisted1247144pers__isted
personable1467074personable_
personae102410554person__ae_
personage12226714person_age_
personages13276534person_ages
personalise1367104personalise
personalises1476524personalises
personalism15137394personalism
personalist1399424personalist
personalities1556474personalities
personality1656334personality
personalize2287334personalize
personalizes2356704personalizes
personalties1485154personalties
personate112111424person_ate_
personates122510694person_ates
personating1447674personating
personation1349484personation
personative1647074personative
personhood1652214person_hood
personnel1143734person__nel
perspired1444214pers_pi_red
petrified1548334pe__trified
preachified2273094preachified
preconized2467144preconi_zed
premodifies19114224premodifies
premonished1953294premonished
prenotifies1644884prenotifies
presanctified2161414presanctified
presifted1536874pres__ifted
presignifies1852704presignifies
prespecified2252594prespecified
prettified1644944p_rettified
purified1438744pur___ified
recodified1765534re_codified
reglorified1652544reglorified
remodified17115264re_modified
renotified1455814re_notified
resinifies1346914re_sinifies
reunified1346594__reunified
saponified1643494_saponified
sermonized22156914sermoni_zed
terrified13147574ter__rified
testified1397844te_s_tified
verbified18146014ver__bified
verified151510394ver___ified
versifier15156534vers__ifier
versifies15159334vers__ifies

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819738.84316829.0
3Display Results73730.0302433.3
 (SQL Overall)178691739.29619222.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.