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

282 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
aby81023806(None) 
ab410674761ab_
aba512850951aba
ably99725131ably
abo59045961abo
abs59356071abs
abye97921001abye
abys97221881abys
any68440481any
ay511773891a_y
baby116723671baby
bay89661641bay
by77529231_by
gaby107123191gaby
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
abas68642082abas
abaya104413172abaya
abba810522642abba
abbe87627182abbe
abbey125714932abbey
abed79734132abed
abet610547942abet
able66340532able
abos67734412abos
abri65522212abri
abut66834952abut
abyes105518532abyes
abysm12598142abysm
abyss10669462abyss
ace59656832ace
achy126316092achy
act59557842act
acyl95314292acyl
ad311975032a_d
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
aery77231682aery
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
agly86821802agly
ago48845522ago
ags47551662ags
ah513868792a_h
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
ai211288392a_i
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
airy75734152airy
ais39083572ais
ait38093902ait
al210674042a_l
ala312463602ala
alb57342652alb
alba68328332alba
albs68628572albs
ale36572342ale
alky115920342alky
all36148232all
ally76935642ally
alp56641132alp
als36663022als
alt36467962alt
am411875562a_m
ama510853302ama
ambo88225132ambo
ambry123512092ambry
ami56646802ami
amp77541022amp
amu58237322amu
amyl95515092amyl
an211879072a_n
ana39559822ana
and47244162and
ane37866942ane
ani37751172ani
ant37270782ant
ape57251182ape
apo511142122apo
app76827602app
apt57352542apt
ar211379382a_r
arb510448422arb
arbs66834732arbs
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
army96624182army
ars37670932ars
art38679142art
arty77531312arty
aryl75922342aryl
as211083072a_s
ash67944602ash
ashy107717352ashy
ask77130702ask
asp57235342asp
ass37844062ass
at212393402a_t
ate37059242ate
att35454652att
auk76234142auk
ava610139322ava
ave67748702ave
avo68936232avo
aw512563402a_w
awa611939672awa
away108024222away
awe67746622awe
awl67635302awl
awn68035912awn
awny105919302awny
awry107619682awry
ax911057782a_x
axe108239492axe
aye67151762aye
ays67050292ays
azo128233392azo
ba49962342_ba
baa510650422baa
baba88828342baba
babe86835812babe
babu85829222babu
bad67763152bad
bag67059222bag
bah87755352bah
bal56662722bal
bam78560142bam
ban58366832ban
bap76455842bap
bar58070552bar
bas58681752bas
bat510988952bat
bays97143912bays
be47948942_be
bey86645422bey
bi48046462_bi
bo410957572_bo
boy87753562boy
buy86436542buy
bye86134592_bye
bys85229462_bys
cab78355402cab_
cabby145314552cabby
cabs86739422cabs
cagy106321992cagy
caky136222442caky
cavy125920002cavy
cay87155982cay
coy810557552coy
cry89726242cry
dab67455562dab_
dabs77139402dabs
dauby115211222dauby
davy116015522davy
day76254112day
dey77243372dey
doby106022162doby
dry76526032dry
easy76224492easy
ebb72418622ebb
fab87453132fab_
fabs98635862fabs
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fry96226502fry
gab67155992gab_
gabby135512942gabby
gabs76740422gabs
gamy105427532gamy
gapy106320912gapy
gay76856492gay
gey75738302gey
goby106021082goby
goy77844552goy
guy75728942guy
habu97325482habu
hay97358772hay
hazy1918119192hazy
hey96741062hey
hoy97447912hoy
icy86322122icy
inby95315652inby
ivy96317442ivy
jab128444112jab_
jabs135830092jabs
jay136242672jay
joy137036362joy
kab97145852kab_
kabs107130842kabs
kay106745542kay
key105833332key
lab58864782lab_
labs67145122labs
lacy95829632lacy
lady86527152lady
laky116725822laky
lamby125114842lamby
lay68865352lay
lazy166423072lazy
ley66246812ley
mabe85733342mabe
many95731842many
may88757622may
mazy186419692mazy
my78125652_my
nab56954922nab_
nabe66029492nabe
nabs66236192nabs
nary76931222nary
navy107518632navy
nay66952772nay
oaky116419952oaky
oba57531552oba
obe56638642obe
obey96521302obey
obi57127722obi
orby97519602orby
oxy136320982oxy
oy58950132_oy
pacy115328682pacy
paly95835532paly
paty95234562paty
pay88461182pay
ply86323552ply
pry85728052pry
racy95825682racy
ray66361992ray
ruby97819942ruby
sab56563202sab_
sabe66140572sabe
sabs66643742sabs
sagy85327082sagy
say67264762say
shy96728192shy
sky106420992sky
sly66228562sly
soy67851452soy
spy86023742spy
sty66227312sty
tab57460322tab_
tabby125213882tabby
tabs66842982tabs
tabu66328492tabu
thy97022912thy
toby96322292toby
toy69655192toy
try66529672try
upby1139062upby
vary105226062vary
wab87051832wab_
wabs97337232wabs
wady115324992wady
waly105830902waly
wany106432352wany
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662way
why126920012why
wry96524702wry
yabby15389742yabby
yay96948712yay
zany167316982zany

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.0632836365.1
2DLD Change Limit140842820.34341061.2
3Display Results2822820.0634476.2
 (SQL Overall)1786912820.469381004.3
 
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.