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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
acetify154500(None) 
acetic10314502aceti_c
acetin8314692aceti_n
acetins9313172acetins
acidify1645242acidify
aerify122810112a_erify
certify1546242_certify
citify1437442_citify
rectify1536452rectify
acedia9310393acedi_a
acedias1039773acedias
acerbity1544273acerbity
aceta74017353acet__a
acetal84314903acet_al
acetals93411353acetals
acetate92514753acetate
acetified1545893acetified
acetifier1444863acetifier
acetifies1447133acetifies
acetifying1944453acetifying
acetone9310793acetone
acetose938843acetose
acetous9410363acetous
acetoxyl2041763acetoxyl
acetum1038463acet_um
acetyl11396553acet_yl
acetyls12285353acetyls
acidity1338593acidity
acidy117214893ac__idy
actin74922553ac_ti_n
acting95920983ac_ting
actins86321103ac_tins
action84719683ac_tion
active11313743ac_tive
acuity1139373ac_uity
acutely1246123acutely
aerily93017013a_erily
alewife1344923alewife
amenity1238333amenity
amplify1744083amplify
apetaly1237253apetaly
artily92814713a_rtily
ascetic11310063asceti_c
ascetics1247073ascetics
beatify1536593beatify
brutify1543883brutify
caitiff1547133caitiff
calcify1735873calcify
carnify1555883carnify
cattily123210853cattily
cecity1398153_cecity
codify1537163_codify
decertify1843463decertify
deify124112763_de_ify
edify12308563__edify
facelift1645773facelift
facetely1643853facetely
facetiae1346213facetiae
faceting1438783faceting
fortify1636523fortify
gratify1436113gratify
identify1544133identify
justify2034663justify
metrify1535623_metrify
mortify1536223mortify
mystify1843563mystify
notify1236943_notify
pacify1667473pac__ify
petrify1536573_petrify
prettify1644343prettify
ratify122610043_ratify
recertify1743643recertify
reedify1465763reedify
reify114814973_re_ify
sanctify1644493sanctify
scarify1537443scarify
scorify1535203scorify
specify1764993specify
tackify1934493tac_kify
testify13246943testify
verify153110163_verify

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 Limit134027816.83019623.3
3Display Results81810.0302700.0
 (SQL Overall)178691817.26624592.8
 
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.