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

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

63 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
implementations2162881implementations_
implementation2063152implementation__
complementation2392694complementation__
implantations1753244impl__antations_
alimentations1594995__alimentations_
cementations1659015___cementations_
depigmentations21102845depigmentations_
implantation1653355impl__antation__
implementing1952705implemen__ti_n_g
implementors1852425implemen__t_ors_
impregnations1853775impre_gn_ations_
lamentations1495985___lamentations_
pigmentations1854095__pigmentations_
placentations17103635__placentations_
presentations1548135__presentations_
representations17153895representations_
supplementation2171895supplementation__
alimentation14105336__alimentation__
argumentations1783276_argumentations_
augmentations1654126__augmentations_
cementation1559706___cementation__
complementaries2372346complementari_es_
depigmentation20103046depigmentation__
documentations19144486_documentations_
emendations1446056____emendations_
explantations2253646expl__antations_
fermentations1856276__fermentations_
fomentations1746796___fomentations_
fragmentations20213566_fragmentations_
illuminations1554446i_llumin_ations_
impartations16135436imp___artations_
impersonations1863656imp_ersonations_
impetrations1645446imp___etrations_
implementers1852726implemen__t_ers_
implementor1752936implemen__t_o__r
implements1647856implemen__t___s_
impletions1445006impl__e___tions_
implications1847026impl___ications_
importations16156146imp___ortations_
imprecations1846276imp__re_cations_
impregnation1754016impre_gn_ation__
imputations1546356imp____utations_
indentations1347886i___ndentations_
inseminations1546246i_nsemin_ations_
lamentation13106576___lamentation__
mentations12312586_____mentations_
miscegenations1963026miscegen_ations_
misorientations1783056misorientations_
molestations1475476_mol__estations_
ornamentations1673256_ornamentations_
perennations1447256__p_erennations_
pigmentation1754486__pigmentation__
placentation1694156__placentation__
plantations1347476__pl__antations_
premeditations1955016__premeditations_
presentation1448996__presentation__
presentational1673216__presentational
regimentations1784856_regimentations_
reimplantations1961906reimpl__antations_
replantations1544866repl__antations_
representation16154126representation__
sedimentations1754416_sedimentations_
segmentations1655596__segmentations_

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 Filter178691658740.326548131.9
2DLD Change Limit65874634.53314532.1
3Display Results63630.0461369.6
 (SQL Overall)178691634.90536430.4
 
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.