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

168 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
jukes16531910(None) 
cukes115422091cukes
dukes105023471dukes
jakes165023641jakes
jokes165423331jokes
jubes145420741jubes
juke154721661juke_
juked175714071juked
jukus16398671jukus
jupes145218551jupes
jutes125125131jutes
nukes95418121nukes
pukes114523021pukes
ukes86122811_ukes
auks85525262auk_s
aures55137092aures
bakes117035372bakes
bikes117529472bikes
bubkes144612622bubkes
bupkes144811482bupkes
burkes124421312burkes
buses75936012buses
butes714535872butes
cakes116037672cakes
cokes115537192cokes
cubes95028162cubes
cues65438982cu_es
cuke105824982cuke_
cures75645432cures
cutes79438312cutes
dekes105224452dekes
dikes105831332dikes
duces86327472duces
dudes75424372dudes
dues56045502du_es
duke95628102duke_
duked115218462duked
dunes65332172dunes
dupes86425932dupes
dures65635922dures
dykes135215572dykes
ekes86726602_ekes
fakes126032482fakes
flukes135114192flukes
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fykes156312692fykes
gudes74520812gudes
gules64831042gules
hakes126034302hakes
hikes125426982hikes
hokes126231642hokes
hues75235232hu_es
jades135222112jades
jake155925772jake_
janes124928122janes
japes146322822japes
jauked18489012jauked
jauks165412462jauk_s
jees115938542j_ees
jefes155613672jefes
jetes124922842jetes
jibes145520322jibes
jives154820812jives
joes116635892j_oes
joke155926162joke_
joked175217912joked
joker165715892joker
jokers175511192jokers
jokey195014692jokey
joles125230832joles
jones125028182jones
jouked18568152jouked
jouks165612342jouk_s
joules134116822joules
jubas144614222jubas
jube136322782jube_
jucos144111712jucos
judas134911882judas
judges153713452judges
judos134711732judos
jugs125525602ju_gs
juices1549422juices
jujus11347462jujus
juku154414852juk_u
julep14310532julep
juleps1535622juleps
jumps165116492jumps
junked184311692junked
junker174213652junker
junkers184010862junkers
junket173815022junket
junkets18377622junkets
junkies183711692junkies
junks164815972junks
jupe134921002jupe_
jurel124516332jurel
jurels133710582jurels
juries134120632juries
jus106930222ju__s
justs124918262justs
jute115327892jute_
juts115930162ju_ts
kikes85122552kikes
kues86426772ku_es
lakes95737652lakes
likes96231902likes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
makes115336852makes
mikes115129892mikes
mokes114631032mokes
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
nudes64723292nudes
nuke85920752nuke_
nuked104014182nuked
okes84936342_okes
pekes114623562pekes
pikes115031032pikes
pokes116133012pokes
pubes94423402pubes
puces94924632puces
puke105025462puke_
puked124716222puked
pules74538812pules
puses75532202puses
quakes194013342quakes
rakes94440352rakes
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
rykes125513032rykes
sakes95540752sakes
sikes96236082sikes
sokes95031422sokes
sues46247652su_es
suks85927122suk_s
supes75628302supes
sykes124816862sykes
takes94437792takes
tikes95628902tikes
tokes95234972tokes
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
tykes125817062tykes
uke75727292_uke_
uses44931112_uses
utes45930882_utes
wakes126633652wakes
yikes125117752yikes
yokes125223022yokes
yuks116418022yuk_s
yules84521582yules

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.0931921408.6
2DLD Change Limit538001681.48336277.8
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.622110167.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.