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 “ignify” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
ignify133451(None) 
dignify1543891dignify
lignify1443791lignify
signify1444851signify
dignity1236462dignity
ignite71410582ignite
magnify1634532magnify
minify1439252minify
nigrify1444132nigrify
uglify1333912uglify
unify113611112_unify
vinify1536922vinify
aerify122810113aerify
agnize16329563agnize
basify1437513basify
biggity1435013biggity
carnify1555883carnify
citify1437443citify
codify1537163codify
cornify1536253cornify
damnify1643453damnify
dandify15245673dandify
deify124112763_deify
densify1435293densify
dingily1238103dingily
edify12308563_edify
fancify1834983fancify
gaily95020973_gaily
gasify1336333gasify
gift86735803_g_ift
ginny95314573gin_ny
gliff124915663_gliff
gonif94320923gonif_
goniff13408893goniff
gonifs104310133gonifs
goofy124915623_goofy
griff124416463_griff
grift95924463_grift
grimy114312603_grimy
gripy115115253_gripy
gulfy124612003_gulfy
icily101211693i_cily
ickily1535753ickily
identify1544133identify
iffy135312283i__ffy
igging93212073igging
ignified1386213ignified
ignifies1277563ignifies
ignifying1744313ignifying
ignited9137623ignited
igniter8147673igniter
ignites81310583ignites
ignitor8125263ignitor
ignobly1342873ignobly
ignominy1443563ignominy
ignore7269063ignore
inanity1039503inanity
inby95315663i_n_by
infix15337773i_nfix
info75617353i_n_fo
inia45024703i_ni_a
inion54620183i_nion
inky115321583i_n_ky
inlay85214323i_nlay
inly75622213i_n_ly
inning73617633inning
ionic74622663ioni_c
ionics84214483ionics
ionise63516943ionise
ionium8610923ionium
ionize154613873ionize
knife1210010143_knife
lenity9612713lenity
lignin74911193ligni_n
lignins84010493lignins
lignite81310303lignite
liquify2244033liquify
lithify1644763lithify
micrify1744693micrify
modify1537173modify
nazify2134233nazify
nidify1336763nidify
nifty115211633__nifty
nitrify1335793nitrify
nixy145714523__nixy
notify1236943notify
ossify1244973ossify
pacify1667473pacify
punily11311773punily
purify14399153purify
ramify14268753ramify
rarify123210063rarify
ratify122610043ratify
reify114814973_reify
reunify1344453reunify
rigidify1642463rigidify
salify12311373salify
sanity9316203sanity
signing92713963signing
signior835043signior
signiory1243563signiory
signory11427523signory
sniff113915863_sniff
sniffy15337193_sniffy
tinily94014433tinily
tinnily1047363tinnily
typify1734523typify
uglily1036193uglily
unity84918493_unity
vanity12311933vanity
verify153110163verify
vilify1536773vilify
vitrify1645003vitrify
vivify1834703vivify
zanily18310183zanily
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 Filter1786911127160.376475242.0
2DLD Change Limit1127161175.61020092.0
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.03229623.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.