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

202 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
publication174657(None) 
publications1845831publications
duplication1647292duplication
lubrication1546342lubrication
plication13311682p__lication
republication1964632republication
rubrication1547122rubrication
sublimation1557182sublimation
abdication1548223_abdication
application1747473application
dubitation1377333dub_itation
duplications1746283duplications
explication2248453explication
fabrication1846603fabrication
imbrication1746463imbrication
implication1747773implication
jubilation1946053jub_ilation
lubrications1645733lubrications
obligation1346783_obligation
palliation1248503palli_ation
placation1339773p__lacation
plications14310493p__lications
pollination1348013pollination
predication16412433predication
prelibation15128663prelibation
prepublication2252923prepublication
publican1444543publica___n
publicities1745483publicities
pullulation1343343pullulation
pulsation1137143pu_l_sation
purification1948173purification
replication15712013replication
republications2074453republications
rubrications1646263rubrications
rustication1349223rustication
sublation11311013subl__ation
sublimations1646083sublimations
subluxation2043823subluxation
sulcation11710733su_l_cation
supplication1855393supplication
umbilication1884743umbilication
urtication1249113_urtication
abdications1657654_abdications
ablation10312434_abl__ation
acclimation17127094acclimation
affliction1843544afflic_tion
allocation1248574_allocation
applications1846774applications
bilocation1446124_bilocation
ciliation111112494_cili_ation
colligation1457444colligation
collimation1557574collimation
collocation1547174collocation
complication2048204complication
culmination1557644culmination
cultivation16116414cultivation
cuspidation1643494cuspidation
cyclization2746414cyclization
debilitation1547784debilitation
declination14411874declination
dedication14311964_dedication
deification17411664deification
dislocation14147504dislocation
dubitations1456674dub_itations
duplicating1745404duplicating
duplicative1954174duplicative
duplicator1544804duplicat_or
edification1749354edification
embolization2547414embolization
embrocation1744584embrocation
equalization3049814equalization
eradication14410114eradication
explications2347534explications
extrication2049794extrication
fabrications1945924fabrications
filiation121110244_fili_ation
foliation121110794_foli_ation
fornication1645954fornication
fulmination1655884fulmination
fumigation1645624fu_migation
furcation1448354fu__rcation
fustigation1545214fustigation
habilitation1795514habilitation
habitation1547914hab_itation
humification2246104humification
humiliation1675194humiliation
idolization2147764idolization
imbrications1845684imbrications
implications1847024implications
inclination1349734inclination
indication13312034_indication
infliction1545944inflic_tion
jubilations2045364jub_ilations
libation102411364___libation
ligation92313094___ligation
location102113914___location
lubricating1644714lubricating
lubricative1853454lubricative
lubricator1444174lubricat_or
mastication15610294mastication
medication15411174_medication
metrication15410654metrication
mislocation15126414mislocation
mobilization2588674mobilization
multination1348974multination
mutilation1249754mu_tilation
nebulization2347194nebulization
nucleation1245964nucl_eation
nullification1854694nullification
oblation1039864_obl__ation
obligations1446144_obligations
obviation1446094_obvi_ation
pacification2168054pacification
pagination1348994p_agination
palliations1347724palli_ations
palmation13310224p_al_mation
palpation1339074p_al_pation
palpitation1546244palpitation
passivation16104744passivation
patination12312574p_atination
pectination15410334pectination
peltation11312964p_el_tation
penalization23512664penalization
pixilation1945914p_ixilation
placations1438584p__lacations
planation11310124p__lanation
pluralization2457084pluralization
pollinations1447234pollinations
predications17411184predications
prediction15410304predic_tion
prelection141511294prelec_tion
prelibations16127624prelibations
prepublications2372664prepublications
privation14311174p__rivation
provocation1847354provocation
publically1944864publica_lly
publicans1544114publica__ns
publicise1544224public__ise
publicising1852764publicising
publicist1545034public__ist
publicity1845034public__ity
publicize2444244public__ize
publicizing2763484publicizing
pullulations1442964pullulations
pulsations1236374pu_l_sations
punctation1486054pu_nctation
punctuation1543484punctuation
punition1038374pu_ni__tion
pupation1269504pu___pation
purgation1247394pu__rgation
purifications2047464purifications
pustulation13116624pustulation
qualification2745034qualification
realization20417224realization
reduplication1855044reduplication
reification16412904reification
reliction11310694_relic_tion
relocation12312114_relocation
relubrication1754504relubrication
replications16811054replications
rubricating1645104rubricating
rubricator1454034rubricat_or
ruination9311274ru__ination
rumination12410834ru_mination
rustications1448564rustications
salivation1349814_salivation
sibilation12128774sib_ilation
sonication12411184_sonication
spoliation1248424spoli_ation
stylization2346674stylization
suballocation1761624suballocation
subduction1544684subduc_tion
suberization2359244suberization
subjection2165974subjec_tion
subjugation2143704subjugation
sublations12410114subl__ations
sublimating1675464sublimating
subluxations2143384subluxations
subornation1346494subornation
subrogation1446004subrogation
subsection1496784subsec_tion
substation1248994sub_station
subtilization2456634subtilization
subtraction1545624subtraction
suffixation2452864suffixation
suffocation1953374suffocation
sulcations1289584su_l_cations
sulfation1288784su_l_fation
supination1249884su_pination
supplications1954914supplications
suspiration1346544suspiration
syndication17124964syndication
triplication1695384triplication
uglification1845494_uglification
ululation938094_u_lulation
umbilications1994414umbilications
unification1648734unification
urination9312174_u_rination
urtications1348034_urtications
utilization2049684utilization
validation1448414_validation
vindication1746354vindication

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.423422437.4
2DLD Change Limit1488192028.90616710.0
3Display Results2022020.1061905.7
 (SQL Overall)1786912029.43518939.2
 
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.