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

235 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
pukes11452302(None) 
cukes115422091cukes
dukes105023471dukes
jukes165319101jukes
nukes95418121nukes
pekes114623561pekes
pikes115031031pikes
pokes116133011pokes
pubes94423401pubes
puces94924631puces
puke105025461puke_
puked124716221puked
pules74538811pules
puses75532201puses
ukes86122811_ukes
auks85525262auk_s
aures55137092aures
bakes117035372bakes
bikes117529472bikes
bubkes144612622bubkes
bupkes144811482bupkes
burkes124421312burkes
buses75936012buses
butes714535872butes
cakes116037672cakes
cokes115537192cokes
cubes95028162cubes
cues65438982cu_es
cuke105824982cuke_
cures75645432cures
cutes79438322cutes
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
opuses84012242opuses
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
pares77164482pares
pases75346502pases
pates76047892pates
pauses84621472pauses
paves104833922paves
paxes144928422paxes
pedes85327292pedes
peeks115021112peeks
pees65257372p_ees
peke105926202peke_
pekoes124410422pekoes
peles75738082peles
penes75839222penes
peres76246642peres
perukes133210112perukes
pes57259782p__es
pies66949602p_ies
pikas114218092pikas
pike106335212pike_
piked125623312piked
piker115622842piker
pikers124717392pikers
pikis115116392pikis
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
plies74526512plies
plumes104318132plumes
pluses83618072pluses
poke105335362poke_
poked125425392poked
poker115122882poker
pokers124617922pokers
pokey145318972pokey
pokeys15529512pokeys
pokies125921332pokies
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
prees75937172prees
pries74339532pries
prudes94215442prudes
prunes83419062prunes
pubis94616472pubis
pubs85029212pu_bs
puce85127882puce_
pucker143817632pucker
puckers153514672puckers
pucks134322102pucks
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
pukka10457132pukka
pule65040952pule_
puled84926522puled
puler74826622puler
pulers83820282pulers
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
pulse74219972pulse
pulses83818662pulses
pumas95121562pumas
pumps115520602pumps
punas74826752punas
pungs85422222pungs
punkas123410672punkas
punker123718822punker
punkers133714852punkers
punkest132611692punkest
punkey154011172punkey
punkeys16366492punkeys
punkies134216802punkies
punks114822682punks
puns66641482pu_ns
punts75828002punts
pupas95219282pupas
pups86032232pu_ps
pupus94614042pupus
pure65543332pure_
puree74632842puree
purees84721682purees
purer75127902purer
purest84021932purest
purges94421762purges
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pu_rs
purse76028892purse
purses84826372purses
pus55547842pu__s
pushes114621662pushes
puss64830132pu_ss
pusses84322842pusses
puts65641752pu_ts
putts75719272putts
putzes174212522putzes
pyes95528992p_yes
pyres105523882pyres
pyxes175911402pyxes
quakes194013342quakes
rakes94440352rakes
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
rykes125513032rykes
sakes95540752sakes
sikes96236082sikes
sokes95031422sokes
spikes124520712spikes
spokes124417212spokes
spues75025382spu_es
spumes1021314882spumes
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 3 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.360496363.9
2DLD Change Limit538002351.65632487.9
3Display Results2352350.0633730.2
 (SQL Overall)1786912352.07985950.5
 
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.