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

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

78 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
superpatriotism2171961superpatriotism_
superpatriotic2081953superpatrioti__c
superpatriots1753823superpatriot_s__
superpatriot1655074superpatriot____
superparasitism2191875superparasitism_
expatriatism2362826___expatriatism_
expatriatisms2462286___expatriatisms
operationism1655866_oper_at_ionism_
operationisms1755096_oper_at_ionisms
patriotism1454206_____patriotism_
patriotisms1553816_____patriotisms
supernations14410876supernat_io_ns__
supernaturalism1992416supernaturalism_
supernutrition1673626supernutri_ti_on
supernutritions1763436supernutri_tions
hypercatabolism2981797hypercatabolism_
hyperparasitism2772517hyperparasitism_
operationist1457947_oper_at_ionis_t
operationists1556057_oper_at_ionists
separationist1555277separ_at_ionis_t
separationists1664087separ_at_ionists
separatism1455607s__e_pa_r_atism_
separatisms1554657s__e_pa_r_atisms
spermatogonia18182637s_permatogoni__a
spermatogonium2171807s_permatogonium_
superaddition1763467super_addi_ti_on
superadditions1863407super_addi_tions
superambitious2072507super_ambi_tious
superathletes1863447super_athletes__
superatom1348917super_at__o___m_
superatoms1448397super_at__o___ms
supercargoes1753947superca_rgo_es__
supercargos1654187superca_rgo__s__
supercarriers1763107supercarri_ers__
supercautious1753927supercautio_us__
supercritical1973487super__cri_tical
superiorities1556327super_iori_ti_es
superlatives1756577superlat_i_ves__
supermajorities2672017supermajori_ti_es
supermarkets2054447superma_rket_s__
supernatants1454477supernat_ant_s__
supernation13411667supernat_io____n
supernational1555617supernat_io__nal
supernaturalist17102627supernaturalis_t
superorganism1862867super__organism_
superorganisms1962287super__organisms
superpersons1654627superp_erso_ns__
superports1447837superp_or__t_s__
superposition17135597superp_osi_ti_on
superpositions18145267superp_osi_tions
superpremium2081947superp__r_emium_
superpremiums2171487superp__r_emiums
superprofit1854347superp__r_ofi__t
superprofits1953467superp__r_ofi_ts
superpros13137237superp__r_o__s__
superrealism1654637super___realism_
superrealisms1753657super___realisms
supersaturates16104427supersaturates__
supersaturating1882737supersaturati_ng
supersaturation1783507supersaturati_on
superscription2063637super_scripti_on
superscriptions2163347super_scriptions
superscripts1864307super_script_s__
superstardom17142617superstardo___m_
superstardoms18162317superstardo___ms
superstations15208147superstatio_ns__
superstition14166877super_st_i_ti_on
superstitions15176787super_st_i_tions
superstitious15175167super_st_i_tious
superstrata1355577super_str_at___a
superstratum1663507super_str_at_um_
superstrikes1855867super_stri_kes__
superstrings15125207super_stri_ngs__
suprematism1754397suprema____tism_
suprematisms1853397suprema____tisms
suprematists1653767supremat_ist_s__
ultrapatriotic1881407_ultrapatrioti__c
unpatriotic1551837_u__npatrioti__c

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 Filter178691950240.360496363.9
2DLD Change Limit95024789.48310020.5
3Display Results78780.0631238.1
 (SQL Overall)178691789.90618038.7
 
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.