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

129 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
tackify193449(None) 
tackily1637501tackily
pacify1667472pac_ify
tackey154613082tack_ey
tackier133712522tackier
tacking144421482tacking
tacky145617442tack__y
wackily1936052wackily
acetify1545003_acetify
acidify1645243_acidify
acidy117214893_ac_idy
acuity1139373_acuity
aerify122810113_aerify
backfit18108213backfit
backing165523443backing
balkily16266693balkily
basify1437513ba_sify
calcify1735873calcify
carnify1555883carnify
cockily1838493cockily
dacoity1366183dacoity
damnify1643453damnify
dandify15245673dandify
falsify1643613falsify
fancify1834983fancify
gasify1336333ga_sify
gawkily1834093gawkily
hackie154615623hacki_e
hackies163418243hackies
hacking173720613hacking
hackly18298733hack_ly
hackney1935123hackney
ickily1535753_ickily
jackies202912623jackies
jacking214515263jacking
jacky215412343jack__y
lacily11612763lac_ily
lackey154813353lack_ey
lacking143821543lacking
lankily1437123lankily
luckily16297083luckily
magnify1634533magnify
micrify1744693micrify
muckily18277743muckily
nazify2134233na_zify
opacify1743653opac_ify
packing164420723packing
packly17228333pack_ly
pawkily1934203pawkily
pockily1846233pockily
racily11715173rac_ily
rackety16499113rackety
racking144323663racking
ramify14268753ra_mify
rarify123210063ra_rify
ratify122610043ra_tify
rectify1536453rectify
sacking144122703sacking
salify12311373sa_lify
salsify1334703salsify
sanctify1644493sanctify
scarify1537443scarify
stacking154215083stacking
stalkily1534823stalkily
stickily1736083stickily
stockily1735443stockily
tachism1478873tachism
tachist12613293tachist
tacit76333673tac_i_t
tacitly1236223tacitly
tack106536293tack___
tacked134723943tack_ed
tacker124224503tack_er
tackers134319623tackers
tacket124627493tack_et
tackets134914363tackets
tackiest143112433tackiest
tackified1944713tackified
tackifier1844143tackifier
tackifies1845783tackifies
tackifying2343803tackifying
tackle123815733tack_le
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
tackling153211123tackling
tacks115430133tack__s
tacrine9311293tacrine
tactic10612753tacti_c
tactics1149323tactics
tactile9310613tactile
taction93213023taction
taffy145110823ta__ffy
takin94921303ta_ki_n
taking114725953ta_king
takins105117403ta_kins
talcking1567083talcking
talcky15294723talck__y
talkie103914443talki_e
talkier114011843talkier
talkies113415733talkies
talking123815823talking
talky126215683talk__y
tanking123918793tanking
tankini11338923tankini
tantivy1335563tantivy
tardily11269583tardily
tariff12711363ta_riff
tartily103511573tartily
tasking124616323tasking
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
techily1537123techily
terrify1336353terrify
testify13246943testify
thacking183110043thacking
ticking143218753ticking
torrify1335013torrify
tracking153715463tracking
trackway20113783trackway
trickily1736233trickily
tucking143415183tucking
typify1734523t_ypify
vacuity1545763vacuity
wackier16369733wackier
wacky174714933wack__y
yacking174315683yacking
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 Limit1340271296.56320421.6
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.01525472.7
 
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.