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

137 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
superlies1131455(None) 
superlie10312121superlie_
duperies11312812duper_ies
superfixes2246822superfixes
superglues1346462superglues
superhits1449112superhits
superliner1249202superliner
superliners1347382superliners
supersizes2149812supersizes
superspies1449292superspies
supervise1449282supervise
supervises1549072supervises
superwides1647772superwides
superwives1847152superwives
supplies1268832sup_plies
aperies9423203_aper_ies
elderlies1044673elderlies
emperies12314563emper_ies
eupepsies1344073eupepsies
ferlies103216693__ferlies
hurlies103315333hu__rlies
japeries17311463japer_ies
moperies12313873moper_ies
naperies10313903naper_ies
orderlies1045453orderlies
overlies112417043_overlies
perlites10316363__perlites
perries93226603__perries
poperies12316793poper_ies
puberties1346603puberties
queries16315873qu_er_ies
roperies10315763roper_ies
ruderies9311333ruder_ies
series64540973s__er_ies
serries73925353s__erries
sherries111812893s_herries
skerries12168673s_kerries
southerlies1453273southerlies
species11314133s_pe_cies
spermines13310543s_permines
spurries102311323s_purries
steelies8312553s_teelies
stupefies1443833stupe_fies
suberins10315093suber_ins
suberise10813933suber_ise
suberises11813453suberises
suberizes20811833suberizes
subseries11312933subser_ies
sudaries9312753sudar_ies
sullies74122233su__llies
sundries9312023sundr_ies
superadds1346413superadds
superber1239693super_ber
superbest1349963super_best
superbness1446663superbness
superbugs1445363superbugs
supercars13410143supercars
supercedes1578453supercedes
supercities15411563supercities
supercity1648813supercity
superclass1446623superclass
superclubs1644513superclubs
supercoils1487493supercoils
supercops1547733supercops
supered10316123super__ed
superegos1246813superegos
superelite1249083superelite
superettes1249743superettes
superfans1448163superfans
superficies1846753superficies
superfine14411443superfine
superfirm1676203superfirm
superfirms1784813superfirms
superfix2045463superfi_x
superfluids1753563superfluids
supergenes13610933supergenes
superglue1246123superglue_
superglued1444663superglued
superhelices1954313superhelices
superhelixes2453623superhelixes
superhit13410503superhi_t
superhypes20135163superhypes
supering11317683super_ing
superior10310883super_ior
superiors11410963superiors
superjet17411783super_jet
superjets1848013superjets
superlain1148993superlain
superlatives1756573superlatives
superlay1347753superl_ay
superlight1646033superlight
superlong1247283superlong
superlying1645383superlying
supermales14410053supermales
supermen12311303super_men
supermind1449043supermind
superminds1547063superminds
supermini1348953supermini
superminis1448553superminis
supermoms1547303supermoms
supernates12413263supernates
superoxides2145333superoxides
superpimp1444473superpimp
superpimps1543873superpimps
superplanes1547433superplanes
superpose1349023superpose
superposes1448933superposes
superpros13137233superpros
superraces1449863superraces
superrich1647083superrich
supers84622403super___s
supersales12411243supersales
supersedes1379423supersedes
supersex1738423super_sex
supersexes1978043supersexes
supersize20410203supersize
supersized2247493supersized
superslick1844833superslick
supertaxes1948083supertaxes
supervenes15610073supervenes
supervised1646663supervised
superwaves1846893superwaves
superwide1548203superwide
superwife1746733superwife
supples11511283sup_pl_es
supplied1345993sup_plied
supplier1246603sup_plier
suppliers1354483sup_pliers
supremes1238363sup_remes
sureties8316583sure_ties
surgeries10311363surger_ies
surlier72915443su__rlier
surliest82416913su__rliest
suzerains1845733suzerains
synergies1345093synergies
underlies101414203underlies
updries10209083_updr_ies

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411376.50022867.8
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.98225593.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.