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

287 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
kebbies153725(None) 
kebbie1435801kebbie_
bobbies103714562bobbies
bubbies103913512bubbies
cabbies133115162cabbies
cubbies133312882cubbies
derbies103016052derbies
dobbies124113062dobbies
hobbies143813342hobbies
hubbies143211562hubbies
kellies113516852kellies
kelpies13289902kelpies
kerries113317912kerries
kewpies16246922kewpies
kibbes143811192kibb_es
kibbis14398462kibbi_s
kibbles153510252kibbles
lobbies113612462lobbies
newbies12147422newbies
pebbles1337572pebbles
rabbies113416052rabbies
rebbes10313532rebb_es
rubbies114114112rubbies
tabbies112913502tabbies
webbier1445422webbier
webbiest1535352webbiest
yabbies14279642yabbies
abbes96723523_abb_es
aeries64737783ae_ries
alibies9313323alibies
ambries111614533ambries
babbles104416323babbles
babies106123643_babies
barbies114519593barbies
beanies93821093beanies
beebees1138013beebees
beedies10314203beedies
belies84631053be_lies
bellies94023723bellies
bennies93917313bennies
berries94423553berries
bevies114017303be_vies
bilbies114712333bilbies
bobbins103410343bobbins
bobbles104514913bobbles
boobies113718203boobies
bries74942153__bries
bubbles104315963bubbles
bubblies1166773bubblies
busbies113011693busbies
cabbie122913343cabbie_
cebids11439163ce_bids
ceboids1237653ceboids
cobbier133410163cobbier
cobbiest14118523cobbiest
cobbles133814823cobbles
corbies113520113corbies
dabbles124514773dabbles
darbies104216983darbies
dearies83526273dearies
debases103814133debases
debates103718523debates
debits94214493de_bits
debones103315113debones
debrides1268723debrides
debrief1337613debrief
debriefs1433533debriefs
debris93311493debri_s
debyes1238103de_byes
decries103319803decries
defies104624053de_fies
deifies113317453deifies
deities82621923deities
dellies83622213dellies
demies94825803de_mies
denies74729643de_nies
derries83124623derries
dexies145018343de_xies
dibbles124013333dibbles
dobbins12379533dobbins
dobies94422083_dobies
doobies103915673doobies
dubbins12358803dubbins
easies64126633_easies
ebbed104111003_ebb_ed
ebbet93517293_ebb_et
ebbets10376833_ebbets
ebbing1137063_ebbing
ebbs82411983_ebb__s
ebonies9312883_ebonies
eddies83313163_eddies
envies9314053_envies
espies83716803_espies
eyries93816813_eyries
fellies104119743fellies
ferlies103216693ferlies
ferries103521083ferries
freebies1337873freebies
gabbier12379633gabbier
gabbiest1337273gabbiest
gabbles124415413gabbles
gabies93820723_gabies
genies75324943ge_nies
gerbils1037303gerbils
gobbles123512583gobbles
gobies95418053_gobies
heavies132713873heavies
hebes105521673he_b_es
heinies102514543heinies
henbits12177003henbits
henries102718283henries
herbier1239593herbier
herbiest1339993herbiest
herries104025073herries
hobbits14317553hobbits
hobbles143313783hobbles
imbibes1334673imbibes
jellies143816533jellies
jemmies18318333jemmies
jennies143511623jennies
jerkies183411583jerkies
jerries143817513jerries
jetties143613123jetties
kauries113613193kauries
kebabs14418503ke_babs
kebars124112493ke_bars
kebbock1643613kebbock
kebbocks1743023kebbocks
kebbuck1642923kebbuck
kebbucks1742353kebbucks
keblahs1634563keblahs
kebobs14427283ke_bobs
keckles12318763keckles
kedges124812943ke_dges
keeves133711983ke_eves
kefirs13396653ke_firs
keirs95313673ke__irs
kelims1278913ke_lims
keloids1288663keloids
kelpie12308613kelpie_
kelvins14106563kelvins
kenches163912273kenches
kentes105118643ke_ntes
kepis115313363ke_pi_s
kerbed13339693kerb_ed
kerbing14308483kerbing
kerbs115013673kerb__s
kermes124616123ke_rmes
kermis124012393kermi_s
kermises14248313kermises
kernes104717523ke_rnes
kernites1269113kernites
kerrias11289513kerrias
ketches164012193ketches
ketenes114813503ketenes
ketones115014503ketones
ketoses114912873ketoses
kettles113411613kettles
kevils13358333ke_vils
kewpie15465413kewpie_
kexes166216813ke__xes
kibbe135211963kibb_e_
kibbeh17406063kibb_eh
kibbehs18354183kibbehs
kibbi13449263kibbi__
kibbitz2443943kibbitz
kibbitzes2641703kibbitzes
kibble143910953kibble_
kibbled16367983kibbled
kibeis12469803kibei_s
kibes115521113k_ib_es
kiddies133412283kiddies
killies113318113killies
kilties113014143kilties
kitties113213623kitties
kneesies1245543kneesies
knobbier1652703knobbier
knobbiest1752883knobbiest
knubbier1642513knubbier
knubbiest1752613knubbiest
koppies153210013koppies
krubis1235003krubi_s
kyries133411373k_yries
lambies113015103lambies
lefties10312073lefties
levies93919863le_vies
lezzies1536203lezzies
lobbied12337173lobbied
loobies93814103loobies
mealies92821933mealies
meanies93620743meanies
meinies92516073meinies
mercies113817563mercies
nebbish1444253nebbish
nebbishes1642973nebbishes
neddies92710703neddies
nellies73418723nellies
newbie11135413newbie_
newies91014073ne_wies
newsies101310383newsies
nibbles114011693nibbles
nobbier11309163nobbier
nobbiest12117773nobbiest
nobbles114014523nobbles
nubbier11308133nubbier
nubbiest12117303nubbiest
nubbins11268023nubbins
nubbles113412433nubbles
peavies122213393peavies
pebble1238003pebble_
pebbled1445393pebbled
pebblier1453263pebblier
pebbliest1543713pebbliest
peeries93623023peeries
pennies94218813pennies
peonies93620153peonies
perries93226603perries
rabbins112811343rabbins
rabbis102613153rabbi_s
rabbits11299863rabbits
rabbles113517973rabbles
rabies85226013_rabies
readies83324703readies
rebaits9312573rebaits
rebates95123173rebates
rebbe9313153rebb_e_
rebids94015523re_bids
rebodies1139153rebodies
reboils94111713reboils
rebores95319163rebores
rebukes134210553rebukes
reburies10311143reburies
rebuses94915293rebuses
redries83721713redries
reflies104418533reflies
refries104419733refries
reifies104218283reifies
relies65036423re_lies
replies94521043replies
reties65436193re_ties
retries74129073retries
ribbier1137583ribbier
ribbiest1237583ribbiest
robbins112811063robbins
rubbles113715113rubbles
rubies84420333_rubies
rugbies10339353rugbies
scabies11613333scabies
selkies113513353selkies
series64540973se_ries
serries73925353serries
skerries12168673skerries
swabbies15115713swabbies
tabbied12297793tabbied
tabbis102910853tabbi_s
tabbises12236523tabbises
techies12513603techies
teddies92711283teddies
tekkies1035943tekkies
tellies73820503tellies
tennies73017973tennies
terbias9310743terbias
terries73425613terries
tobies84521013_tobies
tubbier11237743tubbier
tubbiest12117293tubbiest
veeries102916883veeries
veggies1237553veggies
vegies104314273ve_gies
verbids13259203verbids
verbiles1338913verbiles
wabbles144013993wabbles
wearies103020223wearies
webbed1436433webb_ed
webbing1536123webbing
webbings1633243webbings
websites1335183websites
wedgies123910203wedgies
weenies102915093weenies
weepies122811743weepies
wellies103719073wellies
wobbles143412433wobbles
wobblies15297233wobblies
yabbie13308653yabbie_
yobboes1445583yobboes
zebrines1935883zebrines
zombies2037983zombies

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272876.20321606.8
3Display Results2872870.1102609.1
 (SQL Overall)1786912876.46927622.7
 
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.