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

58 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
typified174392(None) 
typifier1643401typifier
typifies1644961typifies
tepefied1444572tepefied
typifiers1742302typifiers
aerified121310133aerified
amplified17115373amplified
basified1437823basified
citified1438253citified
codified1537403codified
deified123112413_deified
edified12339713_edified
gasified1336533gasified
gypsied1443263gyp_sied
humified1745653humified
ignified1386213ignified
minified1439653minified
modified1537273modified
mystified1845083mystified
nazified2144993nazified
nidified1346763nidified
notified1238363notified
ossified1276433ossified
pacified1638363pacified
pitied94017253__pitied
purified1438743purified
ramified1438043ramified
rarified1239053rarified
ratified12310503ratified
reified112913783_reified
salified12310363salified
spiffed16257103_spiffed
spiffied17234823_spiffied
stupefied1542673stupefied
tackified1944713tackified
tariffed1533723tariffed
tepefies1346893tepefies
terrified13147573terrified
testified1397843testified
tidied83613273t__idied
tiffed13368393t__iffed
torrified13125593torrified
trifid1039063t_rifi_d
trifled113711963t_rifled
tumefied1443353tumefied
typed115815453typ___ed
typhoid1648133typhoi_d
typier1137333typ__ier
typify1734523typif__y
typifying2143323typifying
uglified1345293uglified
unified112413573_unified
unpitied1138793unpitied
verified151510393verified
vilified1547243vilified
vinified1537543vinified
vivified1845893vivified
yuppified2042413yuppified

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 Filter1786911461620.423422437.4
2DLD Change Limit146162586.59322169.3
3Display Results58580.0163625.0
 (SQL Overall)178691587.03225411.1
 
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.