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

268 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
ukes8612281(None) 
cukes115422091cukes
dukes105023471dukes
ekes86726601ekes
jukes165319101jukes
kues86426781kues
nukes95418121nukes
okes84936341okes
pukes114523021pukes
uke75727291uke_
uses44931111uses
utes45930881utes
aces67645092aces
ages55844592ages
akee85936812akee
akees96119242akees
ales47067102ales
anes45255932anes
apes66047432apes
ares45871022ares
ates45047922ates
auks85525262auk_s
aures55137092aures
aves76142602aves
awes76037552awes
axes117337852axes
ayes76543512ayes
bakes117035372bakes
bees65453382bees
bes56557432_bes
bikes117529472bikes
bubkes144612622bubkes
bupkes144811482bupkes
burkes124421312burkes
buses75936012buses
butes714535872butes
byes95230532byes
cakes116037672cakes
cees65941592cees
cokes115537192cokes
cubes95028162cubes
cues65438982cues
cuke105824982cuke_
cures75645432cures
cutes79438322cutes
dees56356632dees
dekes105224452dekes
dies55653532dies
dikes105831332dikes
does56554472does
duces86327472duces
dudes75424372dudes
dues56045502dues
duke95628102duke_
duked115218462duked
dunes65332172dunes
dupes86425932dupes
dures65635922dures
dyes85331892dyes
dykes135215572dykes
eke75630092eke_
eked96718032eked
emes65434662emes
es29048222__es
eses45336102eses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyes75837882eyes
fakes126032482fakes
fees76450602fees
fes66551672_fes
flukes135114192flukes
foes76543442foes
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fykes156312692fykes
gaes56348032gaes
gees55647882gees
gies55641432gies
goes55644092goes
gudes74520812gudes
gules64831042gules
haes77651022haes
hakes126034302hakes
hes66654202_hes
hies74842842hies
hikes125426982hikes
hoes75755732hoes
hokes126231642hokes
hues75235232hues
ices66129642ices
ides57734242ides
ires45639282ires
jakes165023642jakes
jees115938542jees
joes116635892joes
jokes165423332jokes
jubes145420742jubes
juke154721662juke_
juked175714072juked
jukus16398672jukus
jupes145218552jupes
jutes125125132jutes
kaes85734072kaes
kas77058592_kas
kea76540922_kea
keas86337102_keas
kef105639672_kef
kefs115922752_kefs
keg86432552_keg
kegs95824032_kegs
ken76344002_ken
kens85435252_kens
kep96437212_kep
keps106027312_keps
kex146029592_kex
key105833342_key
keys116322172_keys
kikes85122562kikes
kis78051492_kis
kos76944832_kos
kue76631872kue_
kyes115124942kyes
lakes95737652lakes
lees45455882lees
leks85427602leks
les35663072_les
lies46454202lies
likes96231902likes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lues
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
lyes75530832lyes
maes66948402maes
makes115336852makes
mikes115129892mikes
mokes114631032mokes
mules75034292mules
mures75937222mures
muses75134302muses
mutes75033782mutes
noes45845392noes
nudes64723292nudes
nuke85920752nuke_
nuked104014182nuked
obes66036832obes
odes57243242odes
oes35866192_oes
okas85225392okas
oke75839482oke_
okeh114615322okeh
okehs12477462okehs
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owes75137102owes
oxes116530722oxes
oyes74940132oyes
pees65257372pees
pekes114623562pekes
pes57259782_pes
pies66949612pies
pikes115031032pikes
pokes116133012pokes
pubes94423402pubes
puces94924632puces
puke105025462puke_
puked124716222puked
pules74538812pules
puses75532202puses
pyes95528992pyes
quakes194013342quakes
rakes94440352rakes
rees45364192rees
res35565042_res
roes45954142roes
rubes74928412rubes
rues46044482rues
rules55234252rules
runes55530222runes
ruses56136582ruses
ryes75529352ryes
rykes125513032rykes
sakes95540752sakes
sees45361052sees
shes75734352shes
sikes96236082sikes
skas85325712skas
skee85431472skee
skees95023122skees
skeg95316162skeg
skegs105011232skegs
skep105219352skep
skeps115614252skeps
skew116218762skew
skews125413802skews
skies95026842skies
skis84825302skis
sokes95031422sokes
sues46247652sues
suks85927122suk_s
supes75628302supes
sykes124816862sykes
takes94437792takes
tees45353582tees
ties45248322ties
tikes95628902tikes
toes46956442toes
tokes95234972tokes
tres46542902tres
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
tyes76433372tyes
tykes125817062tykes
udos56619902udos
ughs85410972ughs
ukase9428492ukase
ukases10358062ukases
ulus45622562ulus
umps85721942umps
uns35936762u_ns
upas68322382upas
ups55629052u_ps
urbs65922062urbs
urds55922442urds
urea46528062urea
ureas55826012ureas
urges64619912urges
urns46323902urns
urps66920482urps
urus46426142urus
us26937432u__s
use36835162use_
used55722822used
user45023002user
users55817572users
utas45924952utas
ute35335882ute_
uts35534372u_ts
uvea74712652uvea
uveas84912282uveas
vees75439432vees
vies75238632vies
voes75432822voes
waes76048602waes
wakes126633652wakes
wees76249122wees
woes76440662woes
wyes105727502wyes
yes66250612_yes
yikes125117752yikes
yokes125223022yokes
yuks116418022yuk_s
yules84521582yules
zees136331892zees
zeks175815062zeks

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 Filter178691298720.280638182.1
2DLD Change Limit298722680.87634100.5
3Display Results2682680.0803350.0
 (SQL Overall)1786912681.236144572.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.