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

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

166 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
jupes14521855(None) 
dupes86425931dupes
japes146322821japes
jubes145420741jubes
jukes165319101jukes
jupe134921001jupe_
jutes125125131jutes
supes75628301supes
apes66047432_apes
aures55137092aures
bupkes144811482bupkes
buses75936012buses
butes714535872butes
capes95441922capes
cepes94424462cepes
copes97747102copes
coupes105022522coupes
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cupel9514302cupel
cupels10310202cupels
cups85430822cup_s
cures75645432cures
cutes79438322cutes
dopes84935042dopes
drupes94912652drupes
duces86327472duces
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunes65332172dunes
dupe76630602dupe_
duped95118322duped
duper85519002duper
dupers94615602dupers
dups75929512dup_s
dures65635922dures
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
gapes86030822gapes
gudes74520812gudes
gules64831042gules
hopes105835642hopes
hues75235232hu_es
hypes135818672hypes
jades135222112jades
jakes165023642jakes
janes124928122janes
jape134923422jape_
japed156217632japed
japer146218882japer
japers154616172japers
jauped16457902jauped
jaups144810532jaup_s
jeeps144715372jeeps
jees115938542j_ees
jefes155613672jefes
jetes124922842jetes
jibes145520322jibes
jives154820812jives
joes116635892j_oes
jokes165423332jokes
joles125230832joles
jones125028182jones
joules134116822joules
jubas144614222jubas
jube136322782jube_
jucos144111712jucos
judas134911882judas
judges153713462judges
judos134711732judos
jugs125525602ju_gs
juices1549422juices
jujus11347462jujus
juke154721662juke_
juked175714072juked
jukus16398672jukus
julep14310532julep
juleps1535622juleps
jumped183511552jumped
jumper173612372jumper
jumpers18399842jumpers
jumps165116492jumps
junks164815972junks
jupon14479192jupon
jupons15377802jupons
jurel124516332jurel
jurels133710582jurels
juries134120632juries
jus106930222ju__s
justs124918262justs
jute115327892jute_
juts115930162ju_ts
kues86426772ku_es
lopes76437342lopes
loupes84918052loupes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lupus74512522lupus
lures56138532lures
lutes55836662lutes
luxes124921502luxes
mopes95134982mopes
mules75034292mules
mures75937222mures
muses75134302muses
mutes75033782mutes
napes74828462napes
nudes64723292nudes
nukes95418122nukes
opes65942612_opes
ouphes113614632ouphes
ouphs104311272ouphs
pes57259782__pes
pipes96030142pipes
popes95933812popes
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pupas95219282pupas
pups86032232pup_s
pupus94614042pupus
puses75532202puses
rapes75740722rapes
ripes75435772ripes
ropes75940062ropes
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
rupee7321282rupee
rupees8312572rupees
ruses56136582ruses
sipes76036952sipes
spues75025382spues
stupes84116952stupes
sues46247652su_es
supe65932762supe_
super74924482super
supers84622402supers
sups64834432sup_s
tapes75838602tapes
taupes8212672taupes
topes76941762topes
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tups65628762tup_s
tuxes124316042tuxes
types105721062types
ukes86122812_ukes
upas68322382_upas
ups55629052_up_s
uses44931112_uses
utes45930882_utes
wipes104827082wipes
yipes106017842yipes
yules84521582yules
yups96121602yup_s

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001661.48336277.8
3Display Results1661660.0305533.3
 (SQL Overall)1786911661.82697859.3
 
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.