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

71 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
dignify154389(None) 
dignity1236451dignity
ignify1334511_ignify
lignify1443791lignify
signify1444851signify
damnify1643452damnify
dingily1238102dingily
magnify1634532magnify
minify1439252mi_nify
nigrify1444132nigrify
vinify1536922vi_nify
biggity1435013biggity
carnify1555883carnify
citify1437443ci_tify
cornify1536253cornify
dandify15245673dandify
deify124112763d__eify
deigning1137753deigning
densify1435293densify
dicliny1337673dicliny
digamy1335893dig_amy
digging113513703digging
digit73825273dig_i_t
digits84114533dig_its
dignified1545573dignified
dignifies1446363dignifies
dignifying1944153dignifying
dignitary1442463dignitary
dimity12310473di_mity
dingey114914053di_ngey
dinghy14476963di_nghy
dingier93513673dingier
dingies93618243dingies
dinging103618613dinging
dingy105721263di_n_gy
dining84525133di_ning
dinkey144812763di_nkey
dinkly144311083di_nkly
dinky135819373di_n_ky
dinning93416553dinning
dirtily1138583dirtily
disunity1266013disunity
divinity1546163divinity
dizzily1934843dizzily
dulcify1643023dulcify
identify1544133identify
ignite71410583_ignite
indignity1443963indignity
lignin74911193ligni_n
lignins84010493lignins
lignite81310303lignite
liquify2244033liquify
lithify1644763lithify
micrify1744693micrify
nidify1336763ni_dify
nitrify1335793nitrify
reunify1344453reunify
rigidify1642463rigidify
signing92713963signing
signior835043signior
signiory1243563signiory
signory11427523signory
tinily94014433ti_nily
tinnily1047363tinnily
uglify1333913_uglify
unify113611113__unify
vilify1536773vi_lify
vitrify1645003vitrify
vivify1834703vi_vify
zincify2443913zincify
zinkify2643123zinkify

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 Limit134027717.01319111.2
3Display Results71710.0332151.5
 (SQL Overall)178691717.45223978.9
 
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.