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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
sanctifiers165237(None) 
sanctifier1553491sanctifier_
sanctifies1554981sanctifie_s
sanctified1644292sanctifie_d
sanctities1247552sanctitie_s
acetifiers1543403_acetifiers
fancifies1767083fanc_ifie_s
notifiers1245023__notifiers
pacifiers1645463pa_c_ifiers
quantifiers2352503quan_tifiers
ratifiers1236453ra__tifiers
rectifiers1545173_rectifiers
sacrificers18132223sa_crificers
sanitizers19104493saniti_zers
saponifiers1651863saponifiers
satisfiers1342713sa__tisfiers
specifiers1743803spec_ifiers
tackifiers1942933ta_ckifiers
acetifier1444864_acetifier_
acetifies1447134_acetifie_s
acidifiers16113224_acidifiers
actioners1147724_a_ctioners
amplifiers1783664_amplifiers
antilifers1345634_an_tilifers
antiquers1845794_an_tiquers
artificers1543494_a_rtificers
basifiers1445204ba__sifiers
beautifiers1662214beautifiers
calcifies1638924calc_ifie_s
certifiers1545144_certifiers
crucifiers1743074cruc_ifiers
dandifies1476894dan_difie_s
denitrifiers1651914denitrifiers
falsifiers1643234fa_lsifiers
fanciers13358084fanc___iers
fancified1865794fanc_ifie_d
fortifiers1644534_fortifiers
fructifies1843224fructifie_s
gasifiers1344524ga__sifiers
gentrifiers1543004gentrifiers
gratifiers1443864_gratifiers
identifiers1552864identifiers
justifiers2043084_justifiers
lanciers10308544lanc___iers
magnifiers1643814ma_gnifiers
mortifiers1544394_mortifiers
mystifiers1843114_mystifiers
nancified1565544nanc_ifie_d
nitrifiers1343924__nitrifiers
notifier1137424__notifier_
notifies11310424__notifie_s
opacifiers1742514opac_ifiers
pacifier1557504pa_c_ifier_
pacifies15311224pa_c_ifie_s
prettifiers1642514prettifiers
quantifier2243644quan_tifier_
quantifies2244754quan_tifie_s
ratifier1139674ra__tifier_
ratifies11313514ra__tifie_s
rectifier1457734_rectifier_
rectifies14310814_rectifie_s
renotifies1356894renotifie_s
sacrificer17133064sa_crificer_
sacrifices17134414sa_crifices
salifies11314794sa__lifie_s
salsifies1247254sa_lsifie_s
saltiers83411954sa_lt__iers
sanctify1644494sanctif___y
sanctifying2043284sanctifying
sanctimonies1652204sanctimonie_s
sanctioned1343904sanctione_d
sanctions1138874sanct__ions
sanctuaries1353364sanctuarie_s
sandpipers1592854sandpi_pers
sanitaries1049914sanitarie_s
sanities81219774san__itie_s
sanitises91111744saniti_se_s
sanitizer18126734saniti_zer_
sanitizes181210134saniti_ze_s
santirs7312964san_t__i_rs
saponifier1542974saponifier_
saponifies1544714saponifie_s
satirizers1943954sa__tirizers
satisfier1243734sa__tisfier_
satisfies1245324sa__tisfie_s
sauciers1076734sauc___iers
sawtimbers174994sa_wtimbers
scarifiers1544104s_carifiers
scorifiers1543604s_corifiers
signifiers1444184s_ignifiers
simplifiers1862094simplifiers
sniffers14257124s_n__iffers
snifters11318614s_n__ifters
specifier1645684spec_ifier_
specifies1647574spec_ifie_s
stiflers11238834s___tiflers
stratifies1346744stratifie_s
stultifies1343234stultifie_s
tackifier1844144ta_ckifier_
tackifies1845784ta_ckifie_s
tantivies1247104tan_tivie_s
testifiers13124504_testifiers
unifiers11237174_un__ifiers
zincifies2344954zinc_ifie_s

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit1488191049.20616165.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911049.68818444.6
 
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.