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

96 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
maculations156962(None) 
maculation14510981maculation_
acylations1547602_acylations
adulations11310122_adulations
ambulations1547112ambulations
calculations1647072calculations
ejaculations2195212ejaculations
emasculations1754602emasculations
macerations1548472macerations
maculating1549542maculati_ng
maturations1348442maturations
modulations14147262modulations
morulations13148162morulations
osculations1348372osculations
peculations15310282peculations
sacculations1646662sacculations
tabulations1346852tabulations
vacuolations1743772vacuolations
ablations11311513_a_blations
accusations1546003accusations
acidulations15104813_acidulations
actuations1239293_actuations
acylation1448653_acylation_
adulation10311013_adulation_
alations82518893_a__lations
ambulation1447873ambulation_
amputations1546443amputations
angulations1268053angulations
annulations1167833annulations
arcuations1249343arcu_ations
calculation1548293calculation_
cancelations1657093cancelations
caudations13108223ca_udations
causations1268143ca_usations
circulations1648483circulations
coagulations1546513coagulations
copulations151111113copulations
cumulations1547433cumulations
ejaculation2096133ejaculation_
emaciations1548163emac_iations
emasculation1655233emasculation_
emulations12310943_emulations
escalations1347663escalations
evacuations1646303evacu_ations
exculpations2344173exculpations
granulations1345783granulations
gratulations1345173gratulations
halations12312393ha__lations
incubations1547303incubations
inculcations1666313inculcations
inculpations1675963inculpations
inoculations1457683inoculations
insulations11310233insulations
jactations1936893jac_tations
jaculating2047293jaculati_ng
lacerations1348333lacerations
lactations1239423lac_tations
lallations1038743la_llations
laudations1146843la_udations
lobulations1346213lobulations
maceration1449613maceration_
machinations19115763machinations
maculates132013723maculat__es
malathions1543873ma__lathions
manipulations1754113manipulations
marinations13411273marinations
matriculations18144783matriculations
maturation1249513maturation_
mercurations1646563mercurations
modulation13147933modulation_
morulation12148903morulation_
mutations111211453m__utations
mutilations1348643mutilations
nodulations12147003nodulations
occultations1644373occultations
occupations1744543occupations
osculation1249673osculation_
ovulations1337973_ovulations
peculation14311993peculation_
populations15148713populations
regulations12310713regulations
sacculation1547843sacculation_
salutations1147643salutations
saturations1148573saturations
scalations1239783_scalations
simulations1368393simulations
speculations1646393speculations
spiculations1646173spiculations
tabulation1247813tabulation_
ululations1037143_ululations
undulations1246053undulations
vacations141910553vac__ations
vacillations1744873vacillations
vacuolation1644393vacuolation_
vallations1339083va_llations
valuations1348783valu_ations

Search took 5 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 Filter1786911216330.390458182.1
2DLD Change Limit121633964.45327314.8
3Display Results96960.0601600.0
 (SQL Overall)178691964.90336445.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.