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 “kebabs” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

417 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
kebabs1441850(None) 
kababs14409761kababs
kebab134311991kebab_
kebars124112491kebars
kebobs14427281kebobs
debags104211062debags
debars94218042debars
ebbs82411982_eb_bs
kabab134814432kabab_
kabars124513952kabars
kabobs14439292kabobs
kabs107130842k__abs
kbars114612602k_bars
keas86337092ke_a_s
kebar115113532keba_r
keblahs1634562keblahs
kebob135110912kebob_
kenafs1337112kenafs
kerbs115013672ke_rbs
rebars84019822rebars
rehabs1139022rehabs
abas68642083_aba_s
abbas95918643abba_s
abs59356073___abs
akelas10311193akela_s
albas75925393alba_s
amebas10311453ameba_s
baas66844673__baas
baba88828343__baba
babas96325733__babas
babe86835813__babe
babes95834113__babes
babu85829223__babu
babus95620333__babus
baby116723673__baby
bads77048863__bads
bags76645503__bags
bals66354043__bals
bams87044453__bams
bans66555133__bans
baobabs1044443baobabs
baps86040843__baps
barbs95928193__barbs
bars66564093__bars
bas58681753__ba_s
bass66146783__bass
bats66962333__bats
bays97143913__bays
beads85429503be_ads
beaks115326623be_aks
beams95328173be_ams
beans75734693be_ans
bears75739043be_ars
beats76042243be_ats
beaus75127113be_aus
bebops1237623bebops
becaps123811403becaps
bedaubs1233693bedaubs
belays114313853belays
bemas96424283bema_s
betas75528763beta_s
bibbs84911573bib_bs
bibs84830973__bibs
blabs95619633_blabs
bobs86340643__bobs
bubals103513843bubals
bubbas94110703bubbas
bubs86235493__bubs
cabals104020153cabals
cabobs124311883cabobs
cabs86739423__cabs
cebids11439163cebids
cedars93312833cedars
ceibas1038503ceiba_s
celebs1037883celebs
cobbs115013983cob_bs
crabs95421393_crabs
cubebs12508673cubebs
dabs77139403__dabs
deads75726913de_ads
deals65435343de_als
deans66131393de_ans
dears65736883de_ars
debag94212303deba_g
debar85517863deba_r
debark134210943debark
debarks14388493debarks
debase94014473debase
debases103814133debases
debate94419193debate
debates103718523debates
debeaks1436103debeaks
debits94214493debits
debris93311493debris
debs76530243de__bs
debts86418373deb_ts
debugs10467823debugs
debuts93911753debuts
debyes1238103debyes
decafs124010883decafs
decals93717713decals
decays124612913decays
dedans85915073dedans
defats105114553defats
degas75119163dega_s
delays104014053delays
demobs11429483demobs
denars74621433denars
derats74625063derats
derays105514253derays
devas96218883deva_s
dewans105215143dewans
dewars105117073dewars
drabs85119673_drabs
ears46356593_e_ars
eats47054873_e_ats
ebb72418623_eb_b_
ebons74316093_ebons
egads74610923_egads
elans55527753_elans
embars103812873embars
embays131408323embays
eras45441503_era_s
etas46432273_eta_s
exams14199083_exams
eyas76427433_eya_s
eyass84410783_eyass
eyebars1245333eyebars
fabs98635863__fabs
fears84829393fe_ars
feats86432753fe_ats
feebs106112683fe_ebs
ferals94216643ferals
ferbams1435743ferbams
fetas85624403feta_s
feuars938653feuars
flabs105818643_flabs
gabs76740423__gabs
gears64628693ge_ars
gerahs1039413gerahs
getas65421483geta_s
gobans94412043gobans
grabs85719693_grabs
heads95127113he_ads
heals85733453he_als
heaps105223223he_aps
hears86737373he_ars
heats85838403he_ats
hebes105521673heb_es
herbals122710603herbals
herbs105520503he_rbs
hexads17468193hexads
hijabs1833083hijabs
ikebana1342693ikebana
ikebanas1442333ikebanas
isbas71010393isba_s
jabs135830093__jabs
jeans126022113je_ans
jebels15418913jebels
jehads1735833jehads
jibbs16609733jib_bs
jubas144614223juba_s
kaas86531843k__aas
kab97145853k__ab_
kabaka11348503kabaka
kabakas12367403kabakas
kabala124011553kabala
kabalas133911063kabalas
kabar114815553kaba_r
kabaya15387123kabaya
kabayas16316803kabayas
kabob134113923kabob_
kaes85734063k__aes
kafs116423743k__afs
kaiaks937043kaiaks
kakas85117343kaka_s
kalams12310603kalams
kanas95326913kana_s
kanbans1337723kanbans
kapas116021733kapa_s
karats106420493karats
kas77058583k__a_s
kasbahs1634363kasbahs
katas95922093kata_s
kats85944333k__ats
kavas125919953kava_s
kavass13517303kavass
kayaks1236333kayaks
kays116032193k__ays
kbar106514653k_ba_r
kea76540913ke_a__
kebbie1435803kebbie
kebbies1537253kebbies
keblah1545313keblah
kecks105416573ke_cks
keddahs1642923keddahs
kedges124812943kedges
keefs125116283ke_efs
keeks84717253ke_eks
keels94622413ke_els
keens95721183ke_ens
keeps116020283ke_eps
keets95123483ke_ets
keeves133711983keeves
kefirs13396653kefirs
kefs115922743ke__fs
kegs95824013ke__gs
keirs95313673ke_irs
keleps12478813keleps
kelims1278913kelims
kelps115116423ke_lps
kelts95222633ke_lts
kemps135012523ke_mps
kenaf12316033kena_f
kendos114510663kendos
kenos95220623ke_nos
kens85435233ke__ns
kentes105118643kentes
kepis115313363ke_pis
keps106027303ke__ps
kerb104322713ke_rb_
kerfs125413573ke_rfs
kermes124616123kermes
kermis124012393kermis
kernes104717523kernes
kerns94719563ke_rns
ketols104210763ketols
kevels134410713kevels
kevils13358333kevils
kexes166216813ke_xes
keypads1743343keypads
keypals1634353keypals
keys116322163ke__ys
keyways2043373keyways
khafs15648843k_hafs
khans124615173k_hans
khats125316013k_hats
khedahs1852953khedahs
khedas1446313kheda_s
kibbe135211963kib_be
kibbes143811193kibbes
kibbi13449263kib_bi
kibbis14398463kibbis
kibeis12469803kibeis
kibes115521113kib_es
kiblahs1634153kiblahs
kiblas1239323kiblas
kinas95626913kina_s
kitbags1443883kitbags
kivas124614733kiva_s
knaps115511173k_naps
knars94416113k_nars
kneads11357093kneads
knobs11519713k_nobs
koans95818623k_oans
koas85635093k_oa_s
kobos115616893kob_os
kobs105831083k__obs
kolas94822233kola_s
koras95927113kora_s
korats105416063korats
kraals10378433kraals
kulaks976113kulaks
kvas117015943k_va_s
kvass12507273k_vass
kyaks11459163k_yaks
kyars124813963k_yars
kyats125012443k_yats
labs67145123__labs
leads66028493le_ads
leafs85721183le_afs
leaks95923913le_aks
leans55536253le_ans
leaps75522933le_aps
lears55938733le_ars
leas45954183le_a_s
lebens8310093lebens
legals73412733legals
lemans85316393lemans
liblabs1144123liblabs
meads85425323me_ads
meals75933373me_als
means75831223me_ans
meats75034053me_ats
medals94218043medals
megass9219443megass
menads95514383menads
mesas76823203mesa_s
metals84520883metals
nabobs10388203nabobs
nabs66236193__nabs
nawabs1185063nawabs
neaps75618323ne_aps
nears55529423ne_ars
neats55931903ne_ats
nebs66124983ne__bs
nemas75321573nema_s
obas65730933_oba_s
obeahs1135863obeahs
peags86122843pe_ags
peaks114825623pe_aks
peals75235493pe_als
peans75437643pe_ans
pears75138613pe_ars
peas65755063pe_a_s
peats76140193pe_ats
pecans101515833pecans
pedals94316033pedals
pekans121710553pekans
petals84719813petals
pibals103813083pibals
prefabs1435163prefabs
rabats83116223rabats
reads64835273re_ads
reals55038653re_als
reams75729623re_ams
reaps75626193re_aps
rears54739653re_ars
rebait8320403rebait
rebaits9312573rebaits
rebar75420193reba_r
rebate84424103rebate
rebates95123173rebates
rebato83714683rebato
rebatos92913093rebatos
rebbe9313153reb_be
rebbes10313533rebbes
rebecs103913673rebecs
rebels84518133rebels
rebids94015523rebids
rebops10311423rebops
rebs65733563re__bs
rebus75721113reb_us
rebuts84015193rebuts
rebuys11428783rebuys
recaps103615733recaps
redans75421023redans
redbays1336013redbays
redubs9358383redubs
rehab10312443rehab_
relays94316753relays
remans84823003remans
remaps105012873remaps
repass84114703repass
repays113813973repays
resaws93713513resaws
resays93714153resays
retags73414303retags
sabals84618863sabals
sabs66643743__sabs
scabs94818643_scabs
seabags1037483seabags
seals54839693se_als
seams75731663se_ams
sears54744913se_ars
seas45755273se_a_s
seats54844343se_ats
sebums10369813sebums
sedans74816093sedans
selahs9313213selahs
sepals85217373sepals
seracs84418573seracs
serais64326133serais
serdabs1035323serdabs
sewans95215903sewans
sewars94018623sewars
sibbs96211893sib_bs
skeans104512913ske_ans
skibobs1542983skibobs
slabs75322643_slabs
sobas74424253soba_s
squabs17429323squabs
stabs76221383_stabs
subahs114512383subahs
subas74724073suba_s
swabs105817273_swabs
tabs66842983__tabs
teaks94222903te_aks
teals56234133te_als
teams75726513te_ams
tears55436463te_ars
teas45851493te_a_s
teats55636813te_ats
tepals85415043tepals
tepas76521683tepa_s
terais64023503terais
texas126514933texa_s
tubas75119573tuba_s
unbans81912623unbans
unbars82113033unbars
veals84926193ve_als
vegans103910853vegans
velars93913723velars
verbals121910733verbals
verbs104614393ve_rbs
vocabs13336313vocabs
wabs97337233__wabs
weals85428743we_als
weans85326743we_ans
wears86030303we_ars
webby1537143web_by
webcams1643073webcams
webers11310943webers
webs96622123we__bs
wekas123911793weka_s
xebecs17355363xebecs
yeahs115214553ye_ahs
yeans86624883ye_ans
years84527673ye_ars
yeas78638423ye_a_s
yerbas11119293yerba_s
zeals145320853ze_als
zebecs19316183zebecs
zebras1737853zebras
zebrass1834113zebrass
zebus164610053zeb_us
zetas145018163zeta_s

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127164175.45020681.8
3Display Results4174170.1263309.5
 (SQL Overall)1786914175.71931245.1
 
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.