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

100 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
signify144485(None) 
dignify1543891dignify
ignify1334511_ignify
lignify1443791lignify
dignity1236452dignity
magnify1634532magnify
minify1439252mi_nify
nigrify1444132nigrify
signing92713962signing
signior835042signior
signiory1243562signiory
signory11427522signory
vinify1536922vi_nify
biggity1435013biggity
carnify1555883carnify
citify1437443ci_tify
cornify1536253cornify
damnify1643453damnify
dingily1238103dingily
ignite71410583_ignite
lignin74911193ligni_n
lignins84010493lignins
lignite81310303lignite
liquify2244033liquify
lithify1644763lithify
micrify1744693micrify
nidify1336763ni_dify
nitrify1335793nitrify
presignify1952433presignify
resinify1445053resi_nify
reunify1344453reunify
rigidify1642463rigidify
salify12311373s_alify
salsify1334703salsify
sanity9316203s_anity
saponify1644183saponify
scarify1537443scarify
scorify1535203scorify
segni63712483segni__
seignior943313seignior
seigniory1342423seigniory
seignory1244163seignory
shinily13268933shinily
sienite7312713sienite
siganid947203sigani_d
siganids1045303siganids
sighing123311663sighing
sightly14408273sightly
sigil63515503sig_i_l
sigils73912363sig_ils
sign55523053sign___
signa66114703sign__a
signage937773signage
signal73711483sign_al
signally1246533signally
signals8359163signals
signed83413753sign_ed
signee73617233sign_ee
signees83510803signees
signer74015633sign_er
signers84714443signers
signet73621153sign_et
signets83311503signets
significs1543683significs
signified1446043signified
signifier1345713signifier
signifies1347063signifies
signifying1844413signifying
signiori943353signiori
signiors944923signiors
signor73510353sign_or
signora8348503signora
signore8329093signore
signori8347893signori
signors83410913signors
signs65516323sign__s
silicify1644273silicify
silkily14236963silkily
sillily10209783sillily
simplify1843553simplify
sinewy12667513si_newy
singing93221423singing
singly104015853si_ngly
sinning83918443sinning
sniff113915863s__niff
sniffy15337193s__niffy
soggily1235953soggily
specify1764993specify
stingily1236793stingily
stonily1049433stonily
sunnily1037833sunnily
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.1561145455.1
2DLD Change Limit1340271007.30018359.9
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.48623870.0
 
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.