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

137 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
salifying163633(None) 
basifying1845072basifying
calcifying2144492calcifying
coalifying1945032coalifying
falsifying2043752falsifying
gasifying1744522gasifying
nazifying2543472nazifying
pacifying2045502pacifying
qualifying2643972qualifying
ramifying1855602ramifying
rarifying1646312rarifying
ratifying1656822ratifying
salarying1336072salarying
sallying12309852sal_lying
satisfying1743382satisfying
scarifying1945012scarifying
sealifting1444632sealifting
uglifying1743962uglifying
vilifying1944492vilifying
aerifying1636493aerifying
aliasing9310073_aliasing
alibiing1135323_alibiing
aliening91510893_aliening
aligning10158533_aligning
alining81917043_ali_ning
alkalifying2282003alkalifying
allaying12339313_allaying
alloying12339143_alloying
allying113011663_al_lying
amplifying2144123amplifying
beatifying1945733beatifying
carnifying1945043carnifying
casefying1843753casefying
citifying1845383citifying
clarifying1944853clarifying
codifying1944953codifying
dairying1336353da_irying
dallying13368493dal_lying
damnifying2043623damnifying
dandifying1974313dandifying
deifying1637633_deifying
dulcifying2043193dulcifying
edifying1636083_edifying
fancifying2243883fancifying
gallying13328933gal_lying
gratifying1874213gratifying
ignifying1744313ignifying
jellifying2443883jellifying
jollifying2443353jollifying
lifting113313273__lifting
magnifying2044033magnifying
maligning13145583maligning
minifying1845823minifying
modifying1944663modifying
mollifying1944043mollifying
nidifying1744223nidifying
notifying1645623notifying
nullifying1743493nullifying
opacifying2143363opacifying
ossifying1644253ossifying
palsying1436233pal_sying
purifying1835853purifying
rallying12289013ral_lying
rarefying1654693rarefying
reifying1539383_reifying
safetying1643073safetying
sailing83927373sa_i_ling
saining83621393sa_i_ning
sainting93215733sa_inting
salaaming1265363salaaming
salicin9311223sali_cin_
salicine10311703sali_cine
salicins10310933sali_cins
salified12310363salif_ied
salifies11314793salif_ies
salify12311373salify___
salinizing2047433salinizing
salivating1447443salivating
sallowing1357383sallowing
salting84120793sal__ting
saluting9310553sal_uting
salvaging1465283salvaging
salving113913153sal__ving
salvoing1236423sal_voing
sanctifying2043283sanctifying
saponifying2052273saponifying
sashaying1644593sashaying
satiating10311813satiating
savvying1862723sa_vvying
saying104325543sa___ying
sclaffing1843363sclaffing
scorifying1944473scorifying
selfing112911623sel_f_ing
shifting152910383s_hifting
sifting113014593s__ifting
signifying1844413signifying
silicifying2062513silicifying
simplifying2243023simplifying
slaying113316843s_l_aying
slicing103514643s_li_cing
slicking153712593s_licking
sliding93114553s_li_ding
sliming102913953s_li_ming
slimming13288093s_limming
slinging103312863s_linging
slinking133412983s_linking
sliping103314413s_li_ping
slipping133510663s_lipping
slitting93012583s_litting
sluffing15247303s_luffing
sniffing15227453s_niffing
solidifying1952793solidifying
specifying2144683specifying
spiffing17237083s_piffing
spiffying2142753spiffying
splaying14219303spl_aying
splicing1338963spli_cing
splining11310773spli_ning
splinting1238193splinting
splitting1236563splitting
stellifying1842703stellifying
stiffing15248703s_tiffing
stifling122110913s_tifling
stimying1437503s_timying
stratifying1843523stratifying
stultifying1852343stultifying
sullying12328513sul_lying
tackifying2343803tackifying
tallying12318833tal_lying
tariffing1644113tariffing
typifying2143323typifying
unifying1537553_unifying
uplifting1534963uplifting
verifying1936413verifying
vinifying1944713vinifying
vivifying2243843vivifying
waifing142910893wa_if_ing

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411377.42020032.5
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.92322553.5
 
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.