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

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

109 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
affectations204343(None) 
affectation1943841affectation_
affections1845892affec__tions
effectuations2151952effectuations
acceptations1864503acceptations
affection1745893affec__tion_
affiliations1844183affiliations
affirmations2053233affirmations
affixations2443853aff_ixations
afforestations2062243afforestations
assentations1245833assentations
attestations1244463attestations
defecations1779003defec_ations
delectations1547453delectations
effectuation2052283effectuation_
expectations2365843expectations
fetations12511383__fe_tations
infestations1546623infestations
officiations2053503officiations
abdications1657654abdic_ations
aberrations1346694a_berrations
abjections2145674abjec__tions
abnegations1444924abne_gations
accentuations1753094accentuations
acceptation1765324acceptation_
actuations1239294a___ctuations
adaptations1464574a_daptations
advections1645554advec__tions
advocations1755414advoc_ations
aerations9317904a__e_rations
affecting1845234affec__ti_ng
affectional1953894affec__tional
affectioned2052454affec__tioned
affiliation1744854affiliation_
affirmation1953684affirmation_
affixation2344394aff_ixation_
afflictions1943404aff_lictions
afforestation1962364afforestation_
agitations11310064a__gitations
alienations1147884alie_nations
alimentations1594994alimentations
allegations1246044alle_gations
alleviations1554494alleviations
allocations1347774alloc_ations
alterations11511664alte_rations
altercations1446374altercations
alternations1246774alternations
amputations1546444a_mputations
annexations1844264anne_xations
annotations1146884a_nnotations
appellations1643534appellations
appreciations1964754appreciations
arcuations1249344a__rcuations
assentation1146184assentation_
associations1445754associations
attenuations1243804attenuations
attestation1145184attestation_
augmentations1654124augmentations
avocations15168684a_voc_ations
cementations1659014cementations
coarctations16114494coarctations
cunctations1576154_cunctations
defecation1679804defec_ation_
defections161510204defec__tions
delectation1448554delectation_
dentations11413634__dentations
desecrations1559214desecrations
detestations1347584detestations
dictations1389704__dictations
effectuating2151784effectuati_ng
eructations1347234_eructations
execrations2048924_execrations
expectation2266484expectation_
fasciations1646264_fasciations
fellations1338064__fellations
fetation11613144__fe_tation_
flections14239214_flec__tions
flirtations14104264_flirtations
floatations1444104_floatations
flotations1366874__flotations
fluctuations1752564_fluctuations
fomentations1746794fomentations
forestations1546324forestations
furcations1547534_furc_ations
gestations1139774__gestations
hebetations1656464hebe_tations
indentations1347884indentations
infections15510234infec__tions
infestation1447044infestation_
jactations1936894__jactations
lactations1239424__lactations
lamentations1495984lamentations
manifestations1981864manifestations
mentations12312584__mentations
molestations1475474molestations
nictations1278314__nictations
officiation1943834officiation_
orientations1246914orientations
ostentations1246124ostentations
peltations12311554__peltations
punctations1585354_punctations
recitations13314204__recitations
refections151811644refec__tions
refutations1448674ref_utations
reluctations1446754reluctations
restations10315844__restations
speciations1548484_speciations
suffocations2053094suffoc_ations
vegetations1547324vege_tations

Search took 8 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901097.14017477.6
3Display Results1091090.0801362.5
 (SQL Overall)1786911097.61023481.1
 
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.