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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
acculturational1971661acculturational_
acculturation17173343acculturation___
acculturations18182903acculturation__s
acculturating1852554acculturati_n__g
acculturative2062225acculturati___ve
enculturation1552785enculturation___
enculturations1652425enculturation__s
acceleratingly2261326accel_erati_ngly
acceleration1654816accel_eration___
accelerations1754196accel_eration__s
accentuation1653466accentu_ation___
accentuations1753096accentu_ation__s
accommodational2471556accommodational_
acculturate1554326acculturat_____e
acculturated1753196acculturat____ed
acculturates1663506acculturat____es
accumulation18153806accu_mulation___
accumulations19143626accu_mulation__s
accustomation1961936accustomation___
accustomations2061726accustomation__s
adulteration1353666a_dulteration___
adulterations1453176a_dulteration__s
antirational1278496a___ntirational_
arbitrational1553186a_rbit_rational_
calculational1752586__calculational_
enculturating1652436enculturati_n__g
fluctuational1861236_fluctu_ational_
illustrational1461556illust_rational_
maturational1454186___maturational_
multinational1553766__multinational_
multinationals1662226__multinationals
occultation1545136occult__ation___
occultations1644376occult__ation__s
occupational1883006occ___upational_
ultrarational1363516___ultrarational_
aberrational1453487a___berrational_
abstractional1753267a__bst_ractional_
accelerating1753737accel_erati_n__g
accentuating1762837accentu_ati_n__g
acceptation1765327accept__ation___
acceptations1864507accept__ation__s
acclamation17144757acc_l_amation___
acclamations18164047acc_l_amation__s
acclimation17127097acc_l_imation___
acclimations18146297acc_l_imation__s
accretionary1961447acc____retionary
accumulating1953187accu_mulati_n__g
accumulatively2671577accu_mulati_vely
accusation1466907acc___usation___
accusations1546007acc___usation__s
acquisitional2461807acqu__isitional_
actuation11310337a_c__tu_ation___
actuations1239297a_c__tu_ation__s
adaptational1572797a_dapt__ational_
adulterating1453247a_dulterati_n__g
agitational1244847a__git__ational_
alteration10612907a___lteration___
alterations11511667a___lteration__s
antieducational18101547antieducational_
antinational1297487a___ntinational_
aspirational1455007a___spirational_
attritional1154247a____ttritional_
auscultation1453477auscult__ation___
auscultations1553057auscult__ation__s
citational1266467__c_it__ational_
cocultivation2053057cocultivation___
cocultivations2152767cocultivation__s
coeducational1853297__coeducational_
collocational1753057__collocational_
computational1994577__computational_
configurational2162207configurational_
conjugational2353697__conjugational_
conspirational1853967_conspirational_
constructional1854767_constructional_
contractional1756067__cont_ractional_
cultivation16116417__cultivation___
cultivations1745597__cultivation__s
culturati1145437__culturati_____
declinational1652927dec_l_inational_
documentational2061967documentational_
explorational2252557_expl_orational_
fulguration15123337__fulguration___
fulgurations1692797__fulguration__s
incantational1553567incant__ational_
inclinational1553937inc_l_inational_
lactational1344657lac__t__ational_
librational1344557____librational_
multiregional1661857__multiregional_
mutational1246517__mu_t__ational_
nutational1047047__nu_t__ational_
nutritional1154787__nu_t_ritional_
occupationally2362127occ___upationally
orchestrational2071877orchestrational_
oscillational1552237oscil__lational_
perturbational1861207__perturbational_
populational1654417popul___ational_
postulational1553917__postulational_
reputational1474587repu_t__ational_
sacculation1547847saccul___ation___
sacculations1646667saccul___ation__s
salutational1253327__sal_utational_
situational1144587___situ_ational_
structuration15122517structuration___
structurations16122157structuration__s
subrational1345497__su__brational_
suprarational1552927__suprarational_
valuational1444057__val_u_ational_

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 Filter178691950240.390458182.1
2DLD Change Limit950241077.51612642.9
3Display Results1071070.0931150.5
 (SQL Overall)1786911077.99922339.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.