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

70 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
lignify144379(None) 
dignify1543891dignify
ignify1334511_ignify
signify1444851signify
dignity1236452dignity
lignin74911192ligni_n
lignins84010492lignins
lignite81310302lignite
liquify2244032liquify
lithify1644762lithify
magnify1634532magnify
minify1439252mi_nify
nigrify1444132nigrify
vinify1536922vi_nify
aligning10158533aligning
biggity1435013biggity
carnify1555883carnify
citify1437443ci_tify
cornify1536253cornify
damnify1643453damnify
dingily1238103dingily
ignite71410583_ignite
lenity9612713l_enity
lightly14369023lightly
lignan75510323lign_an
lignans8398853lignans
lignified1445063lignified
lignifies1346263lignifies
lignifying1843523lignifying
lignites9129613lignites
lignitic1146393lignitic
limnic10418843limni_c
limning103710323limning
lindy96918313li_n_dy
lineny94011443li_neny
liney87029633li_n_ey
lingier84113383lingier
lingy96925143li_n_gy
linier64423793li_nier
linin58025523li_ni_n
lining74526803li_ning
linins65922143li_nins
linky127622383li_n_ky
linsey938993li_nsey
linty87126563li_n_ty
liny78141323li_n__y
lionise7310373lionise
lionize1668823lionize
liquefy2243013liquefy
logily1039833log_ily
loonily1037073loonily
malignity1543653malignity
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 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.423422437.4
2DLD Change Limit134027706.15621771.8
3Display Results70700.0164375.0
 (SQL Overall)178691706.59527094.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.