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

129 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
sulcation1171073(None) 
sulcations1289581sulcations
sulfation1288781sulfation
furcation1448352furcation
pulsation1137142pulsation
saltation9312002saltation
salvation1239292salvation
siltation939212siltation
solation8916152sol_ation
solvation1237772solvation
sublation11311012sublation
suction93713042su_c_tion
sudation9310802su_dation
sulfations13107812sulfations
summation1347802summation
ablation10312433abl_ation
adulation10311013adul_ation
alation72920553_al_ation
allocation1248573allocation
auction93412933au_c_tion
avocation14168993avocation
bilocation1446123bilocation
cation83925503___cation
ciliation111112493ciliation
collation11313993collation
cunctation1476913cunctation
delation92318083del_ation
dilation92215463dil_ation
duplication1647293duplication
duration9312693du_ration
education12310203education
elation73620453_el_ation
emulation11312393emul_ation
evocation142010293evocation
exultation1747533exultation
fellation1238843fellation
filiation121110243filiation
foliation121110793foliation
function1337843func_tion
furcations1547533furcations
gelation93014433gel_ation
gustation1047963gustation
guttation1046173guttation
halation11313853hal_ation
illation8311943_illation
inculcation1557243inculcation
insulation10311663insul_ation
isolation9311643isol_ation
junction1736203junc_tion
lallation939493lallation
location102113913_location
lunation8311923lu_nation
luxation1538233lu_xation
mutation101412883mu_tation
nucleation1245963nucleation
nunnation9126563nunnation
nutation81513103nu_tation
oblation1039863obl_ation
osculation1249673oscul_ation
ovulation1238983ovul_ation
palmation13310223palmation
palpation1339073palpation
peltation11312963peltation
placation1339773placation
plication13311683plication
publication1746573publication
pulsations1236373pulsations
punctation1486053punctation
pupation1269503pu_pation
purgation1247393purgation
quotation18146973quotation
relation82619773rel_ation
relocation12312113relocation
ruction93611613ru_c_tion
ruination9311273ruination
sacaton938993s_acat_on
salivation1349813salivation
saltations10310623saltations
salutation1048903salutation
salvations1338133salvations
sanction1049533sanc_tion
satiation9313433satiation
scalation11311073scalation
section92515663s_ec_tion
sedation9312453s_edation
selection11311273selection
sensation9510583sensation
seriation9318063seriation
serration9414063serration
siltations1038553siltations
simulation1269583simul_ation
sinuation9310413sinuation
situation949423situation
solations9814623sol_ations
solution889593sol_ution
solvations1336833solvations
sonication12411183sonication
spallation1247023spallation
speciation1449393speciation
spoliation1248423spoliation
squamation2153533squamation
station72717243s__tation
stiction1038823stic_tion
striation9313483striation
suasion739363su__asion
sublations12410113sublations
sublimation1557183sublimation
subluxation2043823subluxation
substation1248993substation
suctions103012903su_c_tions
sudations1039903su_dations
suffocation1953373suffocation
sulcate9314423sulcat__e
sulcated11310373sulcat_ed
sulfating1338063sulfating
sulfonation1444263sulfonation
summations1456783summations
supination1249883supination
supplication1855393supplication
truncation1245453truncation
ulceration1247263_ulceration
ululation938093_ululation
unction9310663_unc_tion
usurpation1243813usurpation
vacation131911893_vacation
vallation1239743vallation
valuation1249973valuation
vocation132311983_vocation
vulcanian1443163vulcanian

Search took 9 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 Filter1786911486410.326548131.9
2DLD Change Limit1486411297.98318619.7
3Display Results1291290.0632047.6
 (SQL Overall)1786911298.37221343.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.