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

82 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
alimentations159499(None) 
alimentation14105331alimentation_
alienations1147882ali_en_ations
augmentations1654122augmentations
lamentations1495982_lamentations
alienation1048793ali_en_ation_
argumentations1783273argumentations
assentations1245833a_ssentations
augmentation1554393augmentation_
cementations1659013_cementations
eliminations1447613elimin_ations
fermentations1856273fermentations
fomentations1746793_fomentations
lamentation13106573_lamentation_
limitations1348183_lim_itations
mentations12312583___mentations
orientations1246913ori_entations
pigmentations1854093pigmentations
placentations17103633placentations
regimentations1784853regimentations
sedimentations1754413sedimentations
segmentations1655593segmentations
abominations1646614abomin_ations
accentuations1753094a_ccentuations
acceptations1864504a_cceptations
affectations2043434a_ffectations
agitations11310064agi___tations
alienating1147234ali_en_ati_ng
alienators1045784ali_en_at_ors
alimenting1344504alimen__ti_ng
allegations1246044al_le_gations
alleviations1554494al_leviations
alliterations1384554allite_rations
alterations11511664al_te_rations
altercations1446374al_tercations
alternations1246774al_ternations
ammoniations1645414a_mmoniations
amputations1546444a__mputations
animations12312194anim___ations
argumentation16103584argumentation_
assentation1146184a_ssentation_
attenuations1243804a_ttenuations
attestations1244464a_ttestations
augmentatives1961934augmentatives
calumniations1763484calum_niations
cementation1559704_cementation_
commendations2055804commendations
criminations1648064crimin_ations
delimitations1676634delim_itations
dentations11413634___dentations
depigmentations21102844depigmentations
documentations19144484documentations
elicitations1446804eli_citations
elimination1348534elimin_ation_
emendations1446054__emendations
fermentation1756824fermentation_
flirtations14104264fli__rtations
fomentation1647714_fomentation_
fragmentations20213564fragmentations
halogenations1772934halogen_ations
imitations1259964__im_itations
implementations2162884implementations
imputations1546354__imputations
indentations1347884_indentations
laminations1339804_lamin_ations
liberations1358944_libe_rations
limitation1249154_lim_itation_
lineations1039544_li__neations
literations11610584_lite_rations
manifestations1981864manifestations
mentation11313984___mentation_
orientation1147574ori_entation_
ornamentations1673254ornamentations
ostentations1246124_ostentations
pigmentation1754484pigmentation_
placentation1694154placentation_
plantations1347474pl__antations
presentations1548134presentations
regimentation1695434regimentation_
sedimentation1654834sedimentation_
segmentation1556004segmentation_
sustentations1354784sustentations

Search took 6 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.360496363.9
2DLD Change Limit95024825.48317330.7
3Display Results82820.0461782.6
 (SQL Overall)178691825.88930343.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.