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

296 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
bye8613459(None) 
abye97921001abye
aye67151761aye
be47948941b_e
bee56262401bee
bey86645421bey
by77529231by_
byes95230531byes
byre95023851byre
bys85229461bys
byte96521811byte
dye75334841dye
eye65539771eye
kye107327271kye
lye66533411lye
pye86432501pye
rye66032541rye
tye65837441tye
wye96331971wye
ye57650061_ye
abbe87627192abbe
able66340532able
aby810238062aby_
abyes105518532abyes
abys97221882abys
ace59656832ace
ae212590292_ae
age47154332age
ale36572342ale
ane37866952ane
ape57251182ape
are37874572are
ate37059242ate
ave67748702ave
awe67746622awe
axe108239492axe
ay511773892ay_
ayes76543512ayes
ays67050292ays
ba49962342b_a
baa510650422baa
babe86835822babe
bad67763152bad
bade75140882bade
bag67059222bag
bah87755352bah
bake105637512bake
bal56662722bal
bale66353842bale
bam78560142bam
ban58366842ban
bane65250432bane
bap76455842bap
bar58070552bar
bare65460522bare
barye105021492barye
bas58681752bas
base64847022base
bat510988952bat
bate66552422bate
bay89661642bay
bayed115423022bayed
bays97143912bays
bed67950622bed
beef96233682beef
been65335782been
beep85931212beep
beer65635992beer
bees65453382bees
beet66457542beet
beg65944132beg
bel57148462bel
ben56554922ben
bene66439492bene
bes56557432bes
bet58376672bet
beys913829552beys
bi48046472b_i
bib77045942bib
bice86235562bice
bid67751792bid
bide76041482bide
bier65531832bier
big67345722big
bike106532602bike
bile66147182bile
bin56658642bin
bine66650862bine
bio57846082bio
bis56860662bis
bise66437102bise
bit57070902bit
bite66547002bite
biz147939362biz
bize155926292bize
blae66134642blae
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
blue65328462blue
blype12429672blype
bo410957572b_o
boa56954032boa
bob76755672bob
bod67055542bod
bode75838752bode
bog67852412bog
bole66448692bole
bone65949322bone
boo58163662boo
bop77549482bop
bore66051332bore
bos57966812bos
bot59680402bot
bow87051902bow
box1210142342box
boy87753562boy
boyo96923842boyo
boys96737332boys
bra56339462bra
brae65639112brae
bred75130972bred
bree67241262bree
bren65629562bren
brew95023562brew
brie65837902brie
bro56236602bro
brr56921922brr
bub76343982bub
bud67041272bud
bug65340742bug
bum75342692bum
bun56348142bun
bur55744692bur
bus56950972bus
but55963022but
bute66739672bute
buy86436542buy
buyer105013092buyer
buys95726792buys
byres104421382byres
byrl95716012byrl
bytes105217492bytes
cee55952702cee
cue57544182cue
cyme119420372cyme
de37049542_de
debye1138902debye
dee47665822dee
dey77243372dey
die46759652die
doe47361952doe
due45249862due
dyed96720762dyed
dyer85522112dyer
dyes85331892dyes
dyke126418182dyke
dyne85320932dyne
eke75630092eke
eme55837182eme
ere36352772ere
eve66331162eve
ewe66630982ewe
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
eyne76322462eyne
eyre75525252eyre
fe57944742_fe
fee66862012fee
fey95940882fey
fie67152442fie
foe66350812foe
fyce126316832fyce
fyke145915292fyke
gae46457702gae
gee45359202gee
gey75738302gey
gie47149542gie
gybe105916242gybe
gym95719062gym
gyp98319012gyp
gyre84722762gyre
gyve116215082gyve
hae67364002hae
he58151952_he
hey96741062hey
hie67652702hie
hoe67562722hoe
hue66642302hue
hyp117822462hyp
hype125519812hype
hyte109018942hyte
ice56737242ice
inbye10427062inbye
ire36943172ire
jee106648642jee
joe106642352joe
kae76744542kae
key105833332key
kue76631862kue
kyes115124932kyes
kyte117017762kyte
lee36068142lee
ley66246812ley
lie38264522lie
lyes75530832lyes
lyre75623792lyre
lyse76320592lyse
mae57659112mae
me47748332_me
my78125652my_
myc106519502myc
nae35952742nae
ne27045102_ne
nee36657782nee
obe56638642obe
obey96521302obey
oboe66822942oboe
ode47446582ode
oe28473062_oe
oke75839482oke
ole37155212ole
one37050912one
ope56845242ope
ore36661832ore
ose38147342ose
owe67041032owe
oy58950132oy_
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
pe47649032_pe
pee56066512pee
pie55457402pie
pya87023752pya
pyes95528992pyes
pyre94925552pyre
pyx157817012pyx
re26153742_re
ree37974072ree
roe36861082roe
rue35549262rue
rya67622012rya
ryes75529352ryes
ryke115616402ryke
sae38365182sae
see35772262see
she66837692she
snye77115492snye
stye76218972stye
sue35651462sue
syce95820282syce
syke115420562syke
syn67024122syn
syne75725762syne
tae38267052tae
tee38366872tee
the67436052the
tie36557532tie
toe310166852toe
tyee75131422tyee
tyer75323392tyer
tyes76433372tyes
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
uke75727292uke
upbye1244792upbye
use36835162use
ute35335882ute
vee65750182vee
vie65447632vie
voe67739052voe
wae67556952wae
we57043452_we
wee66760812wee
woe66651242woe
wyes105727502wyes
wyle105519382wyle
wyn95921442wyn
wyte106018642wyte
ya510251502_ya
yea66445752_yea
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yes66250612_yes
yet66960692_yet
yew96436292_yew
yo59748552_yo
zee126143232zee
zyme1819114942zyme

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.0602978183.3
2DLD Change Limit140842960.36039122.2
3Display Results2962960.0466434.8
 (SQL Overall)1786912960.466383457.1
 
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.