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

157 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
edifying163608(None) 
deifying1637631deifying
aerifying1636492aerifying
codifying1944952codifying
defying15328822_defying
eddying1335292ed_dying
editing9313132edi_ting
modifying1944662modifying
nidifying1744222nidifying
redefying1736092redefying
reedifying1845242reedifying
reifying1539382reifying
unedifying1843722unedifying
unifying1537552unifying
verifying1936412verifying
acetifying1944453acetifying
acidifying2043423acidifying
basifying1845073basifying
beatifying1945733beatifying
bedimming1743643bedimming
bedirtying1742723bedirtying
biffing163510013_biffing
certifying1945313certifying
chivying2034973chivying
citifying1845383citifying
coiffing1755933coiffing
coifing133213893coif_ing
daffing15369733_daffing
dairying1336353dairying
dandifying1974313dandifying
decaying15239453decaying
decoying15208763decoying
decrying15237413decrying
defiling132812463defiling
defining133711803defining
deicing11312193dei_cing
deigning1137753deigning
delaying133210973delaying
densifying1844813densifying
denying123711293_denying
dialing94318173_dialing
dibbing133110893_dibbing
dicing105718763_di_cing
dicking153617613_dicking
dieing84018653_di_eing
dieting93616833_dieting
digging113513703_digging
diking124320243_di_king
dimming13339593_dimming
dinging103618613_dinging
dining84525133_di_ning
dinking133618283_dinking
dinning93416553_dinning
dinting93520553_dinting
dipping134014833_dipping
dirking133812603_dirking
dirling93316073_dirling
dirtying1336093_dirtying
discing113914593_discing
dishing124017103_dishing
disking134615493_disking
dissing94517683_dissing
diving113717953_di_ving
divvying1932773_divvying
dizzying2133023_dizzying
doffing15357793_doffing
draying123813843_draying
drifting13338733drifting
drying113411603_d_rying
dying105316033_d__ying
edging93510713ed__ging
edifice1344933edif_ice
edified12339713edif_ied
edifier11309263edif_ier
edifies113012283edif_ies
edify12308563edify___
educing1137683ed_ucing
eliding93414343eli_ding
embaying1635263embaying
emitting112410353emitting
emptying1634243emptying
enditing10311073endi_ting
enisling949633enisling
enjoying1935003enjoying
enskying1633283enskying
envying1435713e_nvying
epoxying2133033epoxying
espying1336193e_spying
essaying1235033essaying
evicting1437483evicting
evincing1446183evincing
eviting11511373evi_ting
exiling15311083exi_ling
existing1639073existing
exiting15311393exi_ting
eying96117923e___ying
fifing134212343_fif_ing
gasifying1744523gasifying
giddying1533783giddying
gifting123810893_gifting
grifting13299263grifting
ignifying1744313ignifying
jellifying2443883jellifying
knifing1536483knif_ing
lifting113313273_lifting
mediating13311203mediating
metrifying1945683metrifying
miffing16298403_miffing
minifying1845823minifying
nazifying2543473nazifying
notifying1645623notifying
ossifying1644253ossifying
pacifying2045503pacifying
petrifying1945823petrifying
pitying132910243_pitying
purifying1835853purifying
ramifying1855603ramifying
rarifying1646313rarifying
ratifying1656823ratifying
recodifying2144263recodifying
rectifying1946373rectifying
redenying1437783redenying
redialing11311843redialing
redipping1555593redipping
redrying13209023red_rying
remodifying2143853remodifying
resifting133512093resifting
reunifying1745163reunifying
riffing144011273_riffing
rifling112815013_rifling
rifting113515003_rifting
salifying1636333salifying
shifting152910383shifting
sifting113014593_sifting
sniffing15227453sniffing
specifying2144683specifying
spiffing17237083spiffing
spiffying2142753spiffying
stiffing15248703stiffing
stifling122110913stifling
stimying1437503stimying
tepefying1843233tepefying
terrifying1745163terrifying
testifying1745403testifying
tidying1238513_tidying
tiffing14339383_tiffing
trifling122411503trifling
typifying2143323typifying
uglifying1743963uglifying
verbifying2244353verbifying
versifying2045033versifying
vilifying1944493vilifying
vinifying1944713vinifying
vivifying2243843vivifying
waifing142910893waif_ing
whiffing2134703whiffing
wifing133513393_wif_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 Filter1786911461620.406440125.6
2DLD Change Limit1461621577.34319904.9
3Display Results1571570.0762065.8
 (SQL Overall)1786911577.82522835.9
 
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.