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

62 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
superpatriotism217196(None) 
superpatriotic2081952superpatrioti_c
superpatriots1753822superpatriot_s_
superpatriot1655073superpatriot___
superparasitism2191874superparasitism
expatriatism2362825___expatriatism
operationism1655865_oper_at_ionism
patriotism1454205_____patriotism
supernations14410875supernat_io_ns_
supernaturalism1992415supernaturalism
supernutrition1673625supernutri_tion
expatriatisms2462286___expatriatisms
hypercatabolism2981796hypercatabolism
hyperparasitism2772516hyperparasitism
operationisms1755096_oper_at_ionisms
operationist1457946_oper_at_ionist
patriotisms1553816_____patriotisms
separationist1555276separ_at_ionist
separatism1455606s__e_pa_r_atism
spermatogonium2171806s_permatogonium
superaddition1763466super_addi_tion
superathletes1863446super_athletes_
superatom1348916super_at__o___m
superatoms1448396super_at__o_ms_
supercargoes1753946superca_rgo_es_
supercargos1654186superca_rgo__s_
supercarriers1763106supercarri_ers_
supercautious1753926supercautio_us_
superiorities1556326super_iori_ties
superlatives1756576superlat_i_ves_
supermajorities2672016supermajori_ties
supermarkets2054446superma_rket_s_
supernatants1454476supernat_ant_s_
supernation13411666supernat_io___n
supernational1555616supernat_io_nal
supernaturalist17102626supernaturalist
supernutritions1763436supernutri_tions
superorganism1862866super__organism
superpersons1654626superp_erso_ns_
superports1447836superp_or__t_s_
superposition17135596superp_osi_tion
superpremium2081946superp__r_emium
superprofit1854346superp__r_ofi_t
superprofits1953466superp__r_ofits
superpros13137236superp__r_o__s_
superrealism1654636super___realism
supersaturates16104426supersaturates_
supersaturating1882736supersaturating
supersaturation1783506supersaturation
superscription2063636super_scription
superscripts1864306super_script_s_
superstardom17142616superstardo___m
superstardoms18162316superstardo_ms_
superstations15208146superstatio_ns_
superstition14166876super_st_i_tion
superstratum1663506super_str_at_um
superstrikes1855866super_stri_kes_
superstrings15125206super_stri_ngs_
suprematism1754396suprema____tism
suprematists1653766supremat_ist_s_
ultrapatriotic1881406_ultrapatrioti_c
unpatriotic1551836_u__npatrioti_c

Search took 8 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 Limit95024627.14013308.7
3Display Results62620.0331878.8
 (SQL Overall)178691627.53323721.1
 
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.