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

69 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
nigrify144413(None) 
nitrify1335791nitrify
dignify1543892dignify
ignify1334512_ignify
lignify1443792lignify
micrify1744692micrify
nidify1336762ni_dify
signify1444852signify
vitrify1645002vitrify
aerify122810113_aerify
airily93014823ai_rily
angrily1137723angrily
biggity1435013biggity
citify1437443ci_tify
clarify1536093clarify
denitrify1643073denitrify
dignity1236453dignity
fierily1339023fierily
glorify1444583glorify
griff124416463__griff
grift95924463__grift
grimy114312603__grimy
gripy115115253__gripy
horrify1635023horrify
ingraft1199503ingraft
introfy1344753introfy
liquify2244033liquify
lithify1644763lithify
magnify1634533magnify
metrify1535623metrify
midriff1645513midriff
minify1439253mi_nify
nazify2134233n_azify
niftily1335753niftily
niggly11418913nig_gly
nighing123410063nighing
nightly14449033nightly
nighty135611273nig_hty
nigrified1445323nigrified
nigrifies1346363nigrifies
nigrifying1843843nigrifying
nippily1444713nippily
nitric82512063nitri_c
nitrid72812233nitri_d
nitride82811243nitride
nitrids8269633nitrids
nitril62511533nitri_l
nitrile73011373nitrile
nitrils72810703nitrils
nitrite72314463nitrite
notify1236943n_otify
nullify1334713nullify
petrify1536573petrify
purify14399153_purify
rarify123210063_rarify
rigidify1642463rigidify
scarify1537443scarify
scorify1535203scorify
terrify1336353terrify
tigrish1137573tigrish
torrify1335013torrify
uglify1333913_uglify
verify153110163_verify
vilify1536773vi_lify
vinify1536923vi_nify
vivify1834703vi_vify
wirily123310783wi_rily
zincify2443913zincify
zinkify2643123zinkify

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 Limit134027695.62323835.5
3Display Results69690.0302300.0
 (SQL Overall)178691696.05929491.8
 
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.