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

132 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
pacifier155750(None) 
opacifier1643621opacifier
pacified1638361pacified
pacifiers1645471pacifiers
pacifies15311231pacifies
basifier1337312basifier
gasifier1236272gasifier
opacified1744392opacified
opacifiers1742512opacifiers
opacifies1645462opacifies
pacier105018682pac__ier
pacific1646912pacifi_c
pacifism1746382pacifism
pacifist1548092pacifist
purifier1338572purifier
ratifier1139672ratifier
specifier1645682specifier
tackifier1844142tackifier
acetifier1444863_acetifier
achier113914263_ac_hier
acidifier15124383_acidifier
airier64619363_a_irier
backfire1946013backfire
basified1437823basified
basifiers1445203basifiers
basifies13310493basifies
calcified1746893calcified
calcifies1638923calcifies
clarifier1446123clarifier
codifier1447163codifier
crucifier1644313crucifier
daffier1457833da_ffier
deifier113013123_deifier
edifier11309263_edifier
falsifier1544433falsifier
fancified1865793fancified
fancifies1767083fancifies
gasified1336533gasified
gasifiers1344523gasifiers
gasifies1238693gasifies
gratifier1345823gratifier
hacklier1737133hacklier
hairier103111053ha_irier
lacier84020093lac__ier
lucifer1234603lucif_er
magnifier1545273magnifier
modifier1446703modifier
nancified1565543nancified
nazified2144993nazified
nazifies2036063nazifies
notifier1137423notifier
opacities1347943opacities
ossifier111196273ossifier
pacer96131613pac___er
pacifical1845233pacifical
pacifisms1845093pacifisms
pacifists1645063pacifists
pacify1667473pacif__y
pacifying2045503pacifying
packager17136153packager
packer144223403pac__ker
painter93814563pa_inter
paintier1048793paintier
palier85023573pa__lier
pallier94417173pa_llier
palmier113312183pa_lmier
paltrier1037543paltrier
panickier1743173panickier
panier84425503pa__nier
pannier93613353pa_nnier
pappier103511603pa_ppier
parities10522983parities
parrier93717653pa_rrier
partier93520713pa_rtier
pastier94320383pa_stier
patchier15319673patchier
patissier1143193patissier
paucities1348503paucities
paviser12489093pavi_ser
pawkier16236613pa_wkier
peachier1548623peac_hier
peckier153910523pec_kier
petrifier1447123petrifier
pickier153912973pic_kier
pinier84024693p__inier
pipier104913983p__ipier
pitier84019823p__itier
poachier1556823poac_hier
pockier153911603poc_kier
pricier113313113p_ricier
prickier16368143prickier
privier122910453p_rivier
puffier1547973p_uffier
purified1438743purified
purifiers1435883purifiers
purifies13311933purifies
qualifier2145123qualifier
racier85120973rac__ier
rainier71614263ra_inier
ramified1438043ramified
ramifies13310503ramifies
rarefier1135353rarefier
rarified1239053rarified
rarifies11311943rarifies
ratified12310503ratified
ratifiers1236453ratifiers
ratifies11313513ratifies
rectifier1457733rectifier
reifier103414523_reifier
repacified1844893repacified
repacifies1745653repacifies
sacrificer17133063sacrificer
salified12310363salified
salifies11314793salifies
sanctifier1553493sanctifier
satisfier1243733satisfier
scarifier1446653scarifier
spacier114011633spac__ier
specified1746253specified
specifiers1743803specifiers
specifies1647573specifies
tackier133712523tac_kier
tackified1944713tackified
tackifiers1942933tackifiers
tackifies1845783tackifies
typifier1643403typifier
uglifier1244503uglifier
unifier102211863_unifier
verifier14159203verifier
vilifier1456693vilifier
vivifier1745173vivifier
wackier16369733wac_kier

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.436409841.7
2DLD Change Limit1461621326.75021653.6
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.