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

223 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
cukes11542209(None) 
cakes116037671cakes
cokes115537191cokes
cubes95028161cubes
cues65438981cu_es
cuke105824981cuke_
cures75645431cures
cutes79438321cutes
dukes105023471dukes
jukes165319101jukes
nukes95418121nukes
pukes114523021pukes
ukes86122811_ukes
acutes83917722acutes
auks85525262auk_s
aures55137092aures
bakes117035372bakes
bikes117529472bikes
bubkes144612622bubkes
bupkes144811482bupkes
burkes124421312burkes
buses75936012buses
butes714535872butes
cades85440732cades
cafes106426922cafes
cages85936012cages
cake105439962cake_
caked126128622caked
cakey145517272cakey
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cases75048382cases
cates75951892cates
caules85927252caules
causes88026472causes
caves105639702caves
cedes84927332cedes
cees65941592c_ees
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
chokes154917382chokes
chutes114615772chutes
cines75239682cines
cires74932912cires
cites74435592cites
clues74623032clues
codes86247292codes
coke107038382coke_
coked124730692coked
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crakes124921812crakes
cries75438402cries
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
cruxes154911562cruxes
cube85830212cube_
cubeb115814662cubeb
cubebs12508682cubebs
cubed105519702cubed
cuber95222532cuber
cubers105318352cubers
cubs85832382cu_bs
cuds76730472cu_ds
cue57544182cu_e_
cued76329562cu_ed
cuffs135017492cuffs
cuifs104814692cuifs
culet76040342culet
culets85518512culets
culex144613932culex
culls75425812culls
culms95314192culms
cults75022552cults
cunts76125122cunts
cupel9514302cupel
cupels10310202cupels
cups85430822cu_ps
curbs94821652curbs
curds85725612curds
cure66149122cure_
cured85932132cured
curer75030752curer
curers84923192curers
curet75447642curet
curets84922342curets
curfs105122142curfs
curies84934022curies
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cu_rs
curse75829142curse
curses85328272curses
curves114619282curves
cusec94614902cusec
cusecs10509152cusecs
cusks114916052cusks
cusps94913672cusps
cuss65430612cu_ss
cusses84522772cusses
cute66440452cute_
cuter74728232cuter
cutest85820142cutest
cutesy114810732cutesy
cutey105819792cutey
cuteys11569982cuteys
cuties84927362cuties
cutis77723762cutis
cuts65841152cu_ts
cuvee10316142cuvee
cuvees1139372cuvees
cymes1210118922cymes
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
jakes165023642jakes
jokes165423332jokes
jubes145420742jubes
juke154721662juke_
juked175714072juked
jukus16398672jukus
jupes145218552jupes
jutes125125132jutes
kikes85122552kikes
kues86426772ku_es
lakes95737652lakes
likes96231902likes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
luxes124921502luxes
makes115336852makes
mikes115129892mikes
mokes114631032mokes
mules75034292mules
mures75937222mures
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
scutes85219192scutes
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.300595636.7
2DLD Change Limit538002231.48336277.8
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.84696799.0
 
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.