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

350 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
kue7663186(None) 
cue57544181cue
due45249861due
hue66642301hue
kae76744541kae
kues86426771kues
kune85424571kune
kye107327271kye
rue35549261rue
sue35651461sue
uke75727291uke
ace59656832ace
ae212590292_ae
age47154332age
ague55725922ague
akee85936812akee
ale36572342ale
ane37866942ane
ape57251182ape
are37874572are
ate37059242ate
auk76234142auk
ave67748702ave
awe67746622awe
axe108239492axe
aye67151762aye
be47948942_be
bee56262402bee
blue65328462blue
bub76343972bub
bud67041272bud
bug65340742bug
bum75342692bum
bun56348142bun
bur55744692bur
bus56950972bus
but55963022but
bute66739672bute
buy86436542buy
bye86134592bye
cee55952702cee
clue65324532clue
cub76940942cub
cube85830212cube
cud67937452cud
cued76329562cued
cues65438982cues
cuke105824982cuke
cum76440162cum
cup76738242cup
cur56841982cur
cure66149122cure
cut57957662cut
cute66440452cute
de37049542_de
dee47665822dee
die46759652die
doe47361952doe
dub66642202dub
duce76933502duce
dud56737592dud
dude65629662dude
duel56729702duel
dues56045502dues
duet56446262duet
dug58138692dug
duh77930382duh
dui46433382dui
duke95628102duke
dun46545582dun
dune56137582dune
duo48536142duo
dup67637882dup
dupe76630602dupe
dure56341812dure
dye75334842dye
eke75630092eke
eme55837182eme
ere36352772ere
eve66331162eve
ewe66630982ewe
eye65539772eye
fe57944742_fe
fee66862012fee
feu67843662feu
fie67152442fie
flue75329852flue
foe66350812foe
fub86337392fub
fud76335152fud
fuel76824732fuel
fug76234512fug
fume96727632fume
fun66841142fun
fur66637322fur
fuse76429992fuse
fuze166422372fuze
gae46457702gae
gee45359202gee
gie47149542gie
glue55628492glue
grue55825712grue
gude65423332gude
gul45832792gul
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
hae67364002hae
he58151952_he
hie67652702hie
hoe67562722hoe
hub86437482hub
hued86925852hued
hues75235232hues
hug76037362hug
huge86321652huge
huh96432012huh
hum85542932hum
hun65844712hun
hup86437812hup
hut66457292hut
ice56737242ice
ire36943172ire
jee106648642jee
jeu105532072jeu
joe106642352joe
jube136322782jube
jug115529542jug
juke154721662juke
jun105932062jun
jupe134921002jupe
jus106930222jus
jut105944012jut
jute115327892jute
ka69145082k_a
kab97145852kab
kaes85734062kaes
kaf106845512kaf
kale86533752kale
kame105728232kame
kane85133962kane
kas77058582kas
kat77468292kat
kay106745542kay
kea76540912kea
keef115829992keef
keek75624962keek
keel85729462keel
keen84830402keen
keep106329812keep
keet85347332keet
kef105639662kef
keg86432532keg
ken76343982ken
kep96437202kep
kex146029582kex
key105833332key
khet116328622khet
khi106318302khi
ki67537952k_i
kibe106523432kibe
kid86540612kid
kief117128392kief
kier86526802kier
kif105941172kif
kike76524782kike
kin76353962kin
kine85643422kine
kip97042132kip
kir76535672kir
kis78051472kis
kit78559872kit
kite85338232kite
kluge104910452kluge
knee85323602knee
knew115912122knew
knur85311972knur
koa76737772koa
kob99442382kob
koel84519942koel
koi77534742koi
kop97440202kop
kor76538892kor
kore85834162kore
kos76944822kos
kudo96115102kudo
kudu95815422kudu
kufi11910652kufi
kugel1068562kugel
kuna85120702kuna
kuru85521802kuru
kyes115124932kyes
kyte117017762kyte
lee36068142lee
leu36047402leu
lie38264522lie
lube64731562lube
luce65132572luce
lude55331642lude
lues45943552lues
lug46138062lug
luge55531642luge
lum55542932lum
lune47140492lune
lure45142462lure
lute46341012lute
luv67125772luv
lux106528772lux
luxe115222692luxe
lye66533412lye
mae57659102mae
me47748332_me
moue65835572moue
mu46737482mu_
mud67336862mud
mug65837692mug
mule65236972mule
mum76643612mum
mun56143852mun
mure65941332mure
mus55946752mus
muse67136032muse
mut58357182mut
mute65136872mute
nae35952742nae
ne27045102_ne
nee36657782nee
nu26331952nu_
nub56439142nub
nude56626272nude
nuke85920752nuke
nun35537742nun
nus37939392nus
nut36651962nut
obe56638642obe
ode47446582ode
oe28473062_oe
oke75839482oke
ole37155212ole
one37050912one
ope56845242ope
ore36661832ore
ose38147342ose
oud47439072oud
our36042892our
out38072152out
owe67041032owe
pe47649032_pe
pee56066512pee
pie55457402pie
pub76037692pub
puce85127882puce
pud65836652pud
pug65337182pug
puke105025462puke
pul56138062pul
pule65040952pule
pun58846512pun
pup76339882pup
pur56840552pur
pure65543332pure
pus55547842pus
put55759072put
pye86432502pye
qua124821972qua
quey164616472quey
re26153742_re
ree37974072ree
roe36861072roe
roue45941742roue
rub56342822rub
rube65532012rube
rude55632782rude
rued55729792rued
ruer46127562ruer
rues46044482rues
rug46039152rug
rule49938422rule
rum56644642rum
run36244982run
rune45236292rune
ruse45938932ruse
rut35560522rut
rye66032542rye
sae38365182sae
see35772262see
she66837692she
skee85431472skee
skua86113152skua
slue45332192slue
spue66025522spue
sub55445552sub
sued56537932sued
suer45334032suer
sues46247652sues
suet46754822suet
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
supe65932762supe
suq126228992suq
sure45447412sure
tae38267052tae
tee38366872tee
the67436052the
tie36557532tie
toe310166852toe
true46725852true
tub55640032tub
tube65828662tube
tug45937402tug
tui37034022tui
tule45735872tule
tun35845192tun
tune45635862tune
tup56037542tup
tut36758092tut
tux105426572tux
tye65837442tye
uh57429852_uh
ukes86122812ukes
um47338832_um
un28341132_un
up47832822_up
us26937432_us
use36835162use
ut28647032_ut
ute35335882ute
vee65750182vee
vie65447632vie
voe67739052voe
vug76127412vug
vum85428652vum
wae67556952wae
we57043452_we
wee66760812wee
woe66651242woe
wud76227152wud
wye96331972wye
xu96018832xu_
ye57650062_ye
yuk106725602yuk
yule75725142yule
yum86132822yum
yup86031702yup
zee126143232zee
zuz1110622032zuz

Search took 1 second 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 Filter178691140840.0762351197.4
2DLD Change Limit140843500.34341061.2
3Display Results3503500.0804375.0
 (SQL Overall)1786913500.499358098.2
 
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.