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

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

113 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
superior1031088(None) 
superiors11410961superiors
subperiod1445642subperiod
superber1239692superber
supercar1249002supercar
supercop1446462supercop
superhot13410222superhot
supering11317682supering
superiorly1545032superiorly
supermom1446992supermom
superport13410712superport
superpro12136112superpro
supervisor1543942supervisor
anterior8611053anterior
aspersor10336233aspersor
duperies11312813duperies
emperor1155483emper_or
exterior1547373exterior
inferior1156423inferior
interior8513093interior
period9314983__period
prior74316173__p_rior
querier16310013qu_erier
senior63214053s__enior
sneerier878103sneerier
speir75315363s_pe_i_r
spherier1337783spherier
spirier93214073s_pirier
sprier84119063s_p_rier
spurrier10297693spurrier
stertor7310093s_tertor
stupefier1442653stupefier
subeditor1263083subeditor
suberic11312213suberi_c
suberin9314563suberi_n
suberins10315093suberins
suberise10813933suberise
suberize19812153suberize
subperiods1544603subperiods
sugarier937393sugarier
sultrier837773sultrier
summerier1346423summerier
super74924483supe___r
superadd1246653superadd
superatom1348913superatom
superb104410993super__b
superbad1347263superbad
superbly1546983superbly
superboard1546743superboard
superbomb1745183superbomb
superbug1345333superbug
supercars13410143supercars
supercity1648813supercity
supercoil1357753supercoil
supercool1376523supercool
supercops1547733supercops
supered10316123super_ed
superego1146073superego
superegos1246813superegos
superfan1347453superfan
superfarm1686133superfarm
superfine14411443superfine
superfirm1676203superfirm
superfix2045463superfix
supergood1346213supergood
superhero1447043superhero
superhit13410503superhit
superhits1449113superhits
superiority1655863superiority
superjet17411783superjet
superjock2444933superjock
superlay1347753superlay
superlie10312123superlie
superlies11314553superlies
superliner1249203superliner
superlong1247283superlong
superman12310233superman
supermen12311303supermen
supermicro1653893supermicro
supermind1449043supermind
supermini1348953supermini
supermoms1547303supermoms
supernal1039873supernal
supernova1444843supernova
superpimp1444473superpimp
superports1447833superports
superpose1349023superpose
superpower1785453superpower
superpros13137233superpros
superrich1647083superrich
superroad1246743superroad
supers84622403super__s
supersaur11107153supersaur
supersex1738423supersex
supershow1745063supershow
supersize20410203supersize
supersoft1448903supersoft
supersold1277443supersold
superspy1545003superspy
superstar1147573superstar
superstore12108693superstore
supertax1745973supertax
supervise1449283supervise
supervisors1653713supervisors
supervisory1952553supervisory
superwide1548203superwide
superwife1746733superwife
supplier1246603supplier
supremer1246483supremer
supremo1145723supremo_
supremos1245813supremos
suspensor1193383suspensor
ulterior845443ulterior

Search took 9 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621138.26617682.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.76520386.9
 
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.