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

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

101 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
manifestation187199(None) 
manifestations1981861manifestations
infestation1447043_in_festation
reinfestation1664253reinfestation
affectation1943844_a_ffectation
alimentation14105334_alimentation
attestation1145184_a_ttestation
contestation1448664con_testation
disinfestation18113614disinfestation
infestations1546624_in_festations
magnification2145764magnif_ication
manifestant1662504manifesta__nt
manifestants1761694manifesta_nts
manifesting1762734manifes__ting
manifesto1442744manifes__t_o_
manifestoing1861154manifest_oing
manifestos1552244manifes__t_os
manipulation1654664mani_pulation
ministration1465834mini__stration
molestation1365964m__olestation
reinfestations1793884reinfestations
sanitation10412044sani___tation
acceptation1765325_a_cceptation
affectations2043435_a_ffectations
afforestation1962365afforestation
agitation10311225_agi___tation
alienation1048795_ali_e_nation
alimentations1594995_alimentations
animation11313685_ani___mation
annexation1744955_an_ne_xation
annotation1047755_an__notation
assentation1146185_a_ssentation
attestations1244465_a_ttestations
augmentation1554395_augmentation
basification19127325basif_ication
cancelation1547775can_ce_lation
cancellation1655015can_cellation
capitation14311365capi___tation
cavitation1549135cavi___tation
confiscation1945535con_fiscation
confutation1668725con_f_utation
contestations1547735con_testations
dandification2045905dandif_ication
deforestation1754305deforestation
detestation1248365__detestation
disinfestations1993505disinfestations
encrustation14103395_encrustation
facilitation1746575faci_litation
fenestration1596075fen__estration
fetation11613145____fe_tation
forestation1447005__forestation
gasification1867105gasif_ication
gestation10310665____gestation
habilitation1795515habi_litation
habitation1547915habi___tation
incrustation14104435_incrustation
indentation1248375_in_dentation
interstation12410415_interstation
lamentation13106575la__mentation
maceration1449615ma__ce_ration
magnifications2245115magnif_ications
maladaptation1861385maladaptation
malformation1953325ma_lformation
malversation1752725ma_lversation
manifest1339505manifes__t___
manifested1642975manifes__t_ed
manifester1543135manifes__t_er
manifesters1652755manifes__ters
manifestly1852205manifes__t_ly
manifestoed1751515manifes__toed
manifestoes1651975manifes__toes
manifests1444125manifes__t__s
manipulations1754115mani_pulations
marination12312815mari___nation
maximization3255215maxi_mization
meditation13410745medi___tation
mentation11313985m____entation
minimization25127195mini_mization
ministrations1555445mini__strations
miscitation1547775m__iscitation
misestimation1794725m__isestimation
modification20107205modif_ication
molestations1475475m__olestations
nazification2646045nazif_ication
nictation1189275__ni__ctation
orientation1147575_ori_entation
ornamentation1573615ornamentation
pacification2168055pacif_ication
protestation1456365_protestation
ramification1998215ramif_ication
ratification17810665ratif_ication
reforestation1654575reforestation
regimentation1695435regimentation
restation9316915____restation
sanitations11410845sani___tations
sanitization2149155sani_tization
sedimentation1654835sedimentation
unification1648735_unif_ication
variegation1543455vari_e_gation
vinification2068235vinif_ication
vociferation2053185vocife_ration

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.390458182.1
2DLD Change Limit1247901018.58014544.3
3Display Results1011010.0631603.2
 (SQL Overall)1786911019.03319782.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.