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

91 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
superfamilies207346(None) 
stepfamilies1971293s_tepfamilies
subfamilies1852483su__bfamilies
superfamily2153493superfamil__y
superficies1846753superf__icies
superfluities1854143superfluities
materfamilias2061334materfamilias
paterfamilias2061524paterfamilias
supercities15411564super__cities
superfixes2246824superf__i_xes
supergravities2072444supergravities
superiorities1556324superiorities
superlatives1756574superlati_ves
superlies11314554super____lies
supermales14410054super__mal_es
superminis1448554super__mini_s
supersales12411244supersa__l_es
capercaillies1961385capercaillies
capercailzies2861265caperca_ilzies
families1339445_____families
hypergamies2255445hypergam__ies
interfamilial1862745interfamilial
materfamiliases228825materfamiliases
nonfamilies1653195__nonfamilies
overfamiliar2062335_overfamiliar
perfidies1546605__perf__idies
perfumeries1852795__perfumeries
ramilies10311835____r_amilies
specialities1656795s_pecialities
spermaries1468065s_per__maries
spermicides1853315s_per__micides
spermines13310545s_per__mi_nes
spiralities1348015s_pir_alities
superable13312485super_a_bl_e_
superagencies1854745superagencies
superalloys1663075super_a_lloys
superambitious2072505super_ambitious
superathletes1863445super_athletes
supercabinet1855965supercabi_net
supercabinets1953855supercabinets
supercargoes1753945superca_rgoes
supercarrier1663595superca_rrier
supercarriers1763105superca_rriers
supercilious1664535super__cilious
supercivilized31101605supercivilized
supercoiled1655045super_coil_ed
supercoiling1754535super_coiling
supercoils1487495super_coil__s
superfans1448165superfa____ns
superfarms1775385superfa___rms
superfatted1754235superfa__tted
superficial1854405superf__icial
superficiality2462025superficiality
superfine14411445superf__i_ne_
superfirms1784815superf__i_rms
superfluidities21181785superfluidities
superfluidity2261885superfluidity
superfluids1753565superf__luids
superglues1346465super___glues
superheavies2054605super_heavies
superhelices1954315superheli_ces
superhelixes2453625superheli_xes
superhumanities2271635superhumanities
superimposes1852905super_imposes
superlative1648255superlati_ve_
superlie10312125super____lie_
supermajorities2672015supermajorities
supermale1349985super__mal_e_
supermicros1753755super__micros
superminds1547065super__mi_nds
supermini1348955super__mini__
supernates12413265superna___tes
supernations14410875supernati_ons
supernatures1455225superna_tures
superoxides2145335super_oxi_des
superraces1449865superra___ces
supersale11411325supersa__l_e_
superscribes1855145superscri_bes
supersizes2149815super__si_zes
superspies1449295super___spies
superstrikes1855865superstri_kes
supertaxes1948085superta___xes
superthriller18141555superthriller
superthrillers19141095superthrillers
supervirile1654335superviril_e_
supervises1549075super__vi_ses
superwaves1846895superwa___ves
superwides1647775super__wi_des
superwives1847155super__wi_ves
supremacies1773995sup_r_emacies
suzerainties2152665suzer_ainties

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 Limit124790918.95613933.7
3Display Results91910.0631444.4
 (SQL Overall)178691919.40918991.5
 
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.