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

98 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
maculation1451098(None) 
maculations1569621maculations
acylation1448652_acylation
adulation10311012_adulation
ambulation1447872ambulation
calculation1548292calculation
ejaculation2096132ejaculation
emasculation1655232emasculation
maceration1449612maceration
maculating1549542maculating
maturation1249512maturation
modulation13147932modulation
morulation12148902morulation
osculation1249672osculation
peculation14311992peculation
sacculation1547842sacculation
tabulation1247812tabulation
vacuolation1644392vacuolation
ablation10312433_a_blation
accusation1466903accusation
acidulation14105403_acidulation
actuation11310333_actuation
acylations1547603_acylations
adulations11310123_adulations
alation72920553_a__lation
ambulations1547113ambulations
amputation1447343amputation
angulation1149553angulation
annulation1068953annulation
arcuation11410583arcu_ation
calculations1647073calculations
cancelation1547773cancelation
caudation1269993ca_udation
causation1199523ca_usation
circulation1549393circulation
coagulation1447273coagulation
copulation141111953copulation
cumulation1448173cumulation
ejaculations2195213ejaculations
emaciation1449283emac_iation
emasculations1754603emasculations
emulation11312393_emulation
escalation1248873escalation
evacuation1547163evacu_ation
exculpation2244873exculpation
granulation1246553granulation
gratulation1245993gratulation
halation11313853ha__lation
incubation1448363incubation
inculcation1557243inculcation
inculpation1546773inculpation
inoculation1358713inoculation
insulation10311663insulation
jactation1838143jac_tation
jaculating2047293jaculating
laceration1249573laceration
lactation11310813lac_tation
lallation939493la_llation
laudation1088133la_udation
lobulation1247233lobulation
macerations1548473macerations
machination18106823machination
maculate122815623maculat__e
maculated142411503maculat_ed
maculates132013723maculat_es
malathion1444513ma__lathion
manipulation1654663manipulation
marination12312813marination
matriculation17125383matriculation
maturations1348443maturations
mercuration1547493mercuration
modulations14147263modulations
morulations13148163morulations
mutation101412883m__utation
mutilation1249753mutilation
nodulation11127993nodulation
occultation1545133occultation
occupation1645183occupation
osculations1348373osculations
ovulation1238983_ovulation
peculations15310283peculations
population14810023population
regulation11312053regulation
sacculations1646663sacculations
salutation1048903salutation
saturation1049803saturation
scalation11311073_scalation
simulation1269583simulation
speculation1547543speculation
spiculation1547033spiculation
tabulations1346853tabulations
ululation938093_ululation
undulation1147103undulation
vacation131911893vac__ation
vacillation1645313vacillation
vacuolations1743773vacuolations
vallation1239743va_llation
valuation1249973valu_ation

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603985.71624598.1
3Display Results98980.0462130.4
 (SQL Overall)178691986.16828970.7
 
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.