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

130 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
salsify133470(None) 
falsify1643611falsify
salify12311371sal_ify
basify1437512ba_sify
calcify1735872calcify
falsity1335902falsity
gasify1336332ga_sify
saltily10310542saltily
sassily1038722sassily
satisfy1344182satisfy
aerify122810113_aerify
alif76242143_al_if_
alifs86121263_al_ifs
alsike1047913_alsike
balkily16266693balkily
balmily14216463balmily
calif104929103cal_if_
califs114915893cal_ifs
carnify1555883carnify
casefy1436273ca_sefy
clarify1536093clarify
classify1644693classify
coalify1536683coal_ify
damnify1643453damnify
dandify15245673dandify
densify1435293densify
dulcify1643023dulcify
easily9313023ea_sily
emulsify1642703emulsify
falsely1336013falsely
falsie93513853falsi_e
falsies103515013falsies
fancify1834983fancify
gassily1137813gassily
jellify2054543jellify
jollify2044263jollify
kalif125021363kal_if_
kalifs134410983kal_ifs
magnify1634533magnify
massif11412533massif_
massifs1237743massifs
mollify1555503mollify
nazify2134233na_zify
nullify1334713nullify
ossify1244973_ossify
pacify1667473pa_cify
palsied102911303palsied
palsies94420273palsies
palsy105417463pals__y
qualify2235473qual_ify
raisiny10319923raisiny
ramify14268753ra_mify
rarify123210063ra_rify
ratify122610043ra_tify
russify1334063russify
salably121610743salably
salacity1347853salacity
salary9515213sal_ary
salic73424713sal_i_c
salina64221123sal_ina
saline65132703sal_ine
salinity1138893salinity
saliva93110743sal_iva
sallied83316953sallied
sallier73320423sallier
sallies73227813sallies
sallowy13369343sallowy
sally85129713sal__ly
salmi7815863salmi__
salmis8514273salmi_s
salpian938493salpian
salpid9510883salpi_d
salpids1038193salpids
salpinx1636093salpinx
sals46851673sals___
salsa56718923sals__a
salsas65316133sals_as
salsifies1247253salsifies
salsilla844023salsilla
saltie63422433salti_e
saltier74318633saltier
salties73725773salties
saltine75018563saltine
salting84120793salting
saltire73113043saltire
saltish10312163saltish
salty85524383sal__ty
salvia93310753salvi_a
salvias10279933salvias
salvific1643293salvific
salving113913153salving
sanctify1644493sanctify
sanity9316203sa_nity
saponify1644183saponify
sappily1437163sappily
sashay1238363sa_shay
sasin54626573sa_si_n
sasins64923103sa_sins
sassaby1244003sassaby
sassier73413233sassier
sassies74719263sassies
sassing84615553sassing
sassy85813813sa_s_sy
satiny93817983sa_tiny
saucily1237913saucily
savvily1634323savvily
scarify1537443scarify
scorify1535203scorify
sealift10312793seal_ift
signify1444853signify
silicify1644273silicify
silkily14236963silkily
sillily10209783sillily
slily85820033s_l_ily
slimy105417423s_l_imy
sluicy1166483s_luicy
solidify1544193solidify
sparsity1345463sparsity
specify1764993specify
spliff1438603spl_iff
stalkily1534823stalkily
stellify1443883stellify
stultify1442723stultify
subsidy1345973subsidy
sulkily14218113sulkily
tackify1934493tackify
uglify1333913ugl_ify
varsity1356673varsity
versify1636333versify
vilify1536773vil_ify

Search took 9 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 Limit1340271307.75017293.8
3Display Results1301300.0462826.1
 (SQL Overall)1786911308.21921741.2
 
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.