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 “accusationt” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
accusation1466901accusation_
accusations1546001accusations
accusant1246863accusa___nt
accusative1744443accusati_ve
accusatives1862763accusatives
accusatory1743533accusat_ory
actuation11310333actu_ation_
actuations1239293actu_ations
arcuation11410583arcu_ation_
arcuations1249343arcu_ations
causation1199523_causation_
causations1268143_causations
occupation1645183occupation_
occupations1744543occupations
sacculation1547843sacculation_
sacculations1646663sacculations
abjuration1945884abjuration_
abjurations2045144abjurations
acceptation1765324acceptation_
acceptations1864504acceptations
accession1345234acces_sion_
accessions1445254acces_sions
acclamation17144754acclamation_
acclamations18164044acclamations
acclimation17127094acclimation_
acclimations18146294acclimations
accosting1446734accos_ti_ng
accretion1345934acc_retion_
accretions1444924acc_retions
accumulation18153804accumulation_
accumulations19143624accumulations
accusants1344284accusa___nts
accusing1336784accus__i_ng
accustom1443664accus_t_o_m
accustomation1961934accustomation_
accustomations2061724accustomations
accustoms1543344accus_t_oms
acidulation14105404acidulation_
acidulations15104814acidulations
acquaint1945724acqu_a_i_nt
acquisition2252374acquisition_
acquisitions2352164acquisitions
activation15610134activation_
activations1669264activations
actuating1239234actu_ati_ng
acylation1448654a_cylation_
acylations1547604a_cylations
adjuration1845524adjuration_
adjurations1944824adjurations
adulation10311014a_dulation_
adulations11310124a_dulations
ambulation1447874ambulation_
ambulations1547114ambulations
amputation1447344amputation_
amputations1546444amputations
angulation1149554angulation_
angulations1268054angulations
annulation1068954annulation_
annulations1167834annulations
aquatint1749434a_qu_ati_nt
calculation1548294calculation_
calculations1647074calculations
cassation1197914_cassation_
cassations1276874_cassations
caudation1269994_caudation_
caudations13108224_caudations
cessation1176854_cessation_
cessations1256474_cessations
decussation1444304decussation_
decussations1543674decussations
incubation1448364incubation_
incubations1547304incubations
maculation14510984maculation_
maculations1569624maculations
occultation1545134occultation_
occultations1644374occultations
occupational1883004occupational
osculation1249674osculation_
osculations1348374osculations
peculation14311994peculation_
peculations15310284peculations
vaccination1846464vaccination_
vaccinations1945684vaccinations

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.420425454.8
2DLD Change Limit148819839.26616060.8
3Display Results83830.0461804.3
 (SQL Overall)178691839.73218361.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.