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

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

89 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
supplantation176266(None) 
supplantations1862521supplantations
explantation2153973_explantation
implantation1653353_implantation
plantation1248533___plantation
replantation1445523_replantation
supplementation2171893supplementation
supplication1855393suppl_ication
explanation2045264_explan_ation
explantations2253644_explantations
implantations1753244_implantations
planation11310124___plan_ation
plantations1347474___plantations
reimplantation1861934reimplantation
replantations1544864_replantations
sexploitation2252954sexploitation
substantiation1673154substantiation
superannuation16104224superannuation
superfetation1855224superfetation
supernation13411664su_pern_ation
superstation14168624su_perstation
supination1249884su_p_in_ation
supplanting1643924supplan__ting
suppletion1443824suppl___etion
supplications1954914suppl_ications
suppuration1545894supp__uration
sustentation1255024su_stentation
application1747475_appl_ication
augmentation1554395au_gmentation
cupellation1544145cupel__lation
decantation1448945__decantation
dilatation1147395__dila_tation
duplication1647295du_pl_ication
explanations2144625_explan_ations
exploitation2154705_exploitation
impartation15156105_imp_artation
incantation1347055__incantation
lactation11310815____lactation
palpitation1546245__palpitation
peltation11312965__pel__tation
placation1339775___pla_cation
placentation1694155___placentation
planations1238725___plan_ations
plantain1047905___planta_i_n
preimplantation2161365preimplantation
recantation1349865__recantation
reimplantations1961905reimplantations
saltation9312005s____altation
salutation1048905s__al_utation
sanitation10412045s____anitation
sedimentation1654835sedimentation
segmentation1556005s_egmentation
separation12510435s_ep_a_ration
sexploitations2352715sexploitations
siltation939215s__il__tation
spallation1247025s__p_allation
spoliation1248425s_pol__iation
suballocation1761625suballocation
sublation11311015su_bl___ation
sublimation1557185su_bl_imation
subluxation2043825su_bl_uxation
subornation1346495su_born_ation
subpopulation1962665subpopulation
substantiations1772795substantiations
substation1248995su___bstation
sulcation11710735su__l__cation
sulfation1288785su__l__fation
sulfonation1444265su__lfonation
superaddition1763465superaddition
superannuations1763805superannuations
superfetations1975065superfetations
supernations14410875su_pern_ations
superstations15208145su_perstations
superstition14166875su_perstition
supinations1348835su_p_in_ations
supplant1247825supplan__t___
supplanted15113505supplan__t_ed
supplanter14113675supplan__t_er
supplanters15113045supplan__ters
supplants1344875supplan__t__s
suppletions1553575suppl___etions
supplicating1953745suppl_icating
supposition1555205supp__osition
suppurations1645205supp__urations
supranational1552995su_pran_ational
suspiration1346545susp__iration
sustentations1354785su_stentations
transplantation1771875transplantation
trepanation1345485trep_an_ation

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 Filter1786911247900.393454684.5
2DLD Change Limit124790898.65314421.6
3Display Results89890.0631412.7
 (SQL Overall)178691899.10919617.0
 
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.