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

96 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
manifestations198186(None) 
manifestation1871991manifestation_
infestations1546623_in_festations
reinfestations1793883reinfestations
affectations2043434_a_ffectations
alimentations1594994_alimentations
attestations1244464_a_ttestations
contestations1547734con_testations
disinfestations1993504disinfestations
infestation1447044_in_festation_
magnifications2245114magnif_ications
manifestant1662504manifesta___nt
manifestants1761694manifesta__nts
manifesting1762734manifes__ti_ng
manifestoes1651974manifes__t_oes
manifestoing1861154manifest_oi_ng
manifestos1552244manifes__t_o_s
manipulations1754114mani_pulations
ministrations1555444mini__strations
molestations1475474m__olestations
reinfestation1664254reinfestation_
sanitations11410844sani___tations
acceptations1864505_a_cceptations
affectation1943845_a_ffectation_
afforestations2062245afforestations
agitations11310065_agi___tations
alienations1147885_ali_e_nations
alimentation14105335_alimentation_
animations12312195_ani___mations
annexations1844265_an_ne_xations
annotations1146885_an__notations
assentations1245835_a_ssentations
attestation1145185_a_ttestation_
augmentations1654125_augmentations
basifications20137065basif_ications
cancelations1657095can_ce_lations
cancellations1754395can_cellations
capitations1549855capi___tations
cavitations1647845cavi___tations
confiscations2044955con_fiscations
confutations1767795con_f_utations
contestation1448665con_testation_
dandifications2145435dandif_ications
deforestations1853965deforestations
detestations1347585__detestations
disinfestation18113615disinfestation_
encrustations15123085_encrustations
facilitations1845765faci_litations
fenestrations1695405fen__estrations
fetations12511385____fe_tations
forestations1546325__forestations
gasifications19116845gasif_ications
gestations1139775____gestations
habilitations1884865habi_litations
habitations1646885habi___tations
incrustations15134285_incrustations
indentations1347885_in_dentations
lamentations1495985la__mentations
macerations1548475ma__ce_rations
magnification2145765magnif_ication_
maladaptations1961335maladaptations
malformations2053075ma_lformations
malversations1852565ma_lversations
manifesters1652755manifes__t_ers
manifesto1442745manifes__t_o__
manifestoed1751515manifes__t_oed
manifests1444125manifes__t___s
manipulation1654665mani_pulation_
marinations13411275mari___nations
maximizations3354885maxi_mizations
meditations1449335medi___tations
mentations12312585m____entations
minimizations26136555mini_mizations
ministration1465835mini__stration_
miscitations1647055m__iscitations
misestimations18144425m__isestimations
modifications21106985modif_ications
molestation1365965m__olestation_
nazifications2745525nazif_ications
nictations1278315__ni__ctations
orientations1246915_ori_entations
ornamentations1673255ornamentations
pacifications2267355pacif_ications
protestations1555815_protestations
ramifications2087535ramif_ications
ratifications1899785ratif_ications
reforestations1754465reforestations
regimentations1784855regimentations
restations10315845____restations
sanitation10412045sani___tation_
sanitizations2248555sani_tizations
sedimentations1754415sedimentations
unifications1748045_unif_ications
variegations1643455vari_e_gations
vinifications2177695vinif_ications
vociferations2153115vocife_rations

Search took 7 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 Limit95024965.67316750.2
3Display Results96960.0601600.0
 (SQL Overall)178691966.09329327.3
 
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.